Solved How to check duplicate on a form on two fields

[amjadinsaudia]

I added the following variable in module but still facing with same error.

Dim thisID As Long

 

[arnelgp]

you add it on the Form. see my Last post (#21), those codes are from the Form.

 

[amjadinsaudia]

@arnelgp

I have attached my db, if you please can define the variable thisID at an appropriate level?

I have tried to adjust it various times on different levels but not successful.

Second thing, this duplicate check only works for the data displaying in form currently and do not check for any other existing record in the table if entered drawing no. is already available in other section / unit.

Thank you so much in advance.

 

[arnelgp]

see Hint subform code.
you have a lot of mistake on your combobox rowsource.

 

[amjadinsaudia]

@arnelgp
I must admit the support you have given to me. Thanks a lot.
for defining the variable I was doing it at main hint from and this did not thought to put it on a sub form.
Warm regards,