Working with QueryDefs and ADO...

[ETCallHome]

Hi,

I think I moved up a notch from novice, I have created all my tables and forms, but now I need to make sure that data entered has not been previously entered after the user entered the information. I have tried the DLookup function but it only works on one field or can you use it to check for more than one field in the syntax.

I have read up on DOA and ADO, but I am a little confused, can someone please help to get me started....

1. I would like to use the Examine Data function to retrieve the data using a select statement.

2. Not sure how to start...



Thanks

[orange]

Could you please tell us more about " Examine Data function"?

And tell us about what you are doing/attempting?