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

Posted on 2012-09-04
Last Modified: 2012-09-04
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 :)
Question by:Ian Leason
    LVL 119

    Accepted Solution

    see this link

    Use NotInList Event to Add a Record to Combo Box

    Author Closing Comment

    by:Ian Leason
    That is absolutely fantastic thank you so much :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now