Auto populate to add to combo box


A

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!
 
Ad

Advertisements

A

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.

Linq Adams via AccessMonster.com said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top