fairly new at access

Posted on 2011-10-30
Last Modified: 2013-11-27
I'm fairly new at form building - not sure what "based on the employeemain table" means.  Is this a macro or VBA?  i have a table and I have a form.  The form gathers info from the table or tables.  I would guess that my question is more detailed:
1.  I have have a blank form with employee ID, first and last name.  I want the user to enter the employee ID (thats it) and access go and retrieve first/last name from table and place it on the form.
2.  I assume I will need a command button to click OK or cancel prior to retrieving the info.  Ok to retrieve and cancel to close form.  I know how to build the cancel piece.  
3.  Where do i put the cmd script?

Thanks - i'm learning!
Question by:dpearson10
    LVL 77

    Accepted Solution

    That isn't really how a standard Access form would work, although you could program it that way.

    But if you create your form from the table, so that it you can browse through all records,  you can then add a combo box to the form header.  The combo box wizard includes an option to 'find a record in my form' and you use that option to create a combo box that will find a particular record.   Once you have built it you select a record in the dropdown list and the details of that record are displayed.

    You can follow the steps of the wizard to add the combo box.

    Author Closing Comment

    I'll keep trying and learning... thanks

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now