Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Crestview Hills, Kentucky, USA
    Thanked 0 Times in 0 Posts

    Form auto data entry (Access 97)

    I have a table containing Fields 1, 2, 3, 4, 5, and 6. I want to create a form in which I enter Field 1 and Field 2 data. The form will look up this combination of Field 1 and Field 2 data and automatically fill in Fields 3, 4, 5, and 6. This combination of data will be given an ID number and placed in a separate table, along with some other data entered on the form. Is this possible?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Form auto data entry (Access 97)

    I would create combo boxes on the form that let the user select existing values for Field1 and Field2.

    Are the data in Field1 and Field2 completely independent of each other, or should the choice for Field2 be limited to those corresponding to the value selected for Field1? The sample database Solutions.mdb that comes with Access 97 contains examples of doing this. Or see ACC: How to Synchronize Two Combo Boxes on a Form.

Posting Permissions

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