Auto populate to add to combo box

[Amelia]

Okay, I have couple combo boxes on my form. I will start with my one labeld
[Customer Name]. I have it so if I enter a name that is not in my Customer
List it will ask if you want to add it. When you click yes it opens a form
called Customer Information. When it opens Customer Information it opens it
to the first record. What I want it to do is open the form to a new record
and populate in the data already entered in the Customer Name field.

How do I make this happen? I know it is possible, I just don't have the
expierence yet.

I am using Access 2007. Thanks again, you guys give great advice!

 

[Amelia]

Thanks for the reply, however, I am not sure where you expect me to put this.

I tried in the after update event and that did not work.
I already have it set up to open the form I need if the item I put in the
text box is not in the list. I just need it to copy the information.

DoCmd.OpenForm "Customer Information", , , , acFormAdd

Okay, I have couple combo boxes on my form. I will start with my one labeld
[Customer Name]. I have it so if I enter a name that is not in my Customer
List it will ask if you want to add it. When you click yes it opens a form
called Customer Information. When it opens Customer Information it opens it
to the first record. What I want it to do is open the form to a new record
and populate in the data already entered in the Customer Name field.

How do I make this happen? I know it is possible, I just don't have the
expierence yet.

I am using Access 2007. Thanks again, you guys give great advice!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com