• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

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 Leason
Ian Leason
1 Solution
Rey Obrero (Capricorn1)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 :)

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now