how to open form Add items when the item is not exists?

[siamandm]

Hello All,

if I have a form to add items to a table, and if the item is not recorded in the tbl_items, how to check the item is not exist and open form to record items.?


Regards

[burrina]

If DCount("SomeFieldName", "SomeTable", "SomeField=Forms!YourFormName!]!SomeField") < 1 Then

HTH

[siamandm]

thanks a lot @ burrina for the quick reply, i will give a try and see