Form to Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am still learning how to work with forms so any help would be appreciated.

I have a table that has the following fields

UniqueIdentifier
Rep
CompName
Citycode

Basically what I am trying to do is on my form the user can select his/her
name (Rep) from a combo box and then it will pop up all of the information
associated with that rep. The user needs to be able to make changes so
basically if it could pop up the actual table specific to the rep that would
be great.

Right now I have it populating a list box but I can't make changes in the
list box.

Any ideas?
 
I am going to make the assumption that 'rep' is in a different table
Working on that assumption, create an unbound combo box. Use th
wizard. Choose the last option 'Find a record' etc etc Choose th
table where 'rep' resides. Choose the field from the table. Now whe
you pick an entry from the combo box, its associated data will b
populated in the form
 
Back
Top