Records Exist ??

[Lanason]

hi guys,

I have a form with 2 fields (Despatch Note Number and Customer Code) on it - I want to check a table to see if a record exists with these 2 fields.

Is there a simple bit of code I can use to do this?

 

[John Big Booty]

Re: Records Exisit ??

You could use the DCount() function to check if that combination already exists.

 

[Lanason]

Re: Records Exisit ??

You could use the DCount() function to check if that combination already exists.

tried that but could not get the syntax working - so I used a select query and counted the number of records found. Also gave me good control over the records selected