Access 2007

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.

well, you can do this in a few different ways. the easiest is to let the database do if for you. if you're new to database design, i suggest reading up on database normalization. it will make things a lot easier. anyway, by making a field unique, you're telling the db to not insert a value if it already exists.
first, what are you using to denote a customer? Username, email address, first name + last name? what ever you choose, you will need to either make it a primary (or compound primary) key or make it unique. By doing this, the database will not allow you to enter a value that already exists.

Another way would be to do a select query first, then, if it returns null, run the update query. It's usually always easier, and best practice, to let the dbms (data base management system) enforce integrity. If you have more questions let me know

jason

Hi Jason, sorry for the late respond.

As far as letting the db do it itself, I apologize for not explaining well enough.

The problem is I am wanting to pull the info from the user table, and merging it with a different table and adding to that second table. But my problem lies that when i try to do so right now, it tries to add the record to the user table. Im trying to figure out how to make it so it only adds it to the second table.

Thanks again for the help

can you post your code? You can use Select Into statement to select values from one table(s) and insert them into another. Let me see what your sql looks like and we can go from there