Hello guys. I'm kinda new to this forum, but I have a question.

I have an Access 2007 form. The form pulls the data from a query.

Now, what kind of code could I use in VB to assign the current data (that is being displayed into forms) into variables.

To explain what I am trying to do:

The form pops up, and displays the current data of a customer. I want to be able to add a new customer, while checking that the customer does not exist.

Thanks for any help.