How to open a form, go to new record and copy data from current form

Hi, I am going to do my best to explain this clearly - I am using simple names for the controls to make it easier:

In Access 2003:

I have two forms - Form1 and Form2
Form1 contains a ComboBox - Combo1
Form2 contains a TextBox - Text1
Combo1 is limited to the drop down list and when something that is not in the drop down is entered it asks if they want to add it. When the user answers yes I want to do the following:

Open Form2 and go to a new record on Form2
Copy the text from Combo1 to Text1
The user can then add additional info on Form 2
When they close Form2 the Combo1 is updated and the text entered displayed

I hope that makes sense. Thanx in advance :)
Ian LeasonAsked:
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this link

Use NotInList Event to Add a Record to Combo Box
Ian LeasonAuthor Commented:
That is absolutely fantastic thank you so much :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.