Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Forms-autopopulating

    What I would like to do is the following:

    1. When using a form for entering data, I want to enter in a employee ID, then in the two fields below, I would like the last name and first name to automatically filter in from the tables after entering in the employee ID.

    2. When chosing a Class ID from a drop-down (combo box), I want the other information (class title, location, date, time) that is linked to the class ID to automatically filter into the empty fields below.

    Is this even possible? How do I do it!?

  2. #2
    Join Date
    May 2004
    New York State
    The easy/easy way? Use a command button. Create it using the Command Button Wizard. Under Categories, choose Record Navigation (the default); under Actions, choose Find Record. Complete making the wizard entries, and at the end, Access will create the code for you.

    Depending on your form's Record Source property, and whether you're using bound or unbound text boxes, you may need to manually (with code, of course) populate the other text boxes.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts