Form Data/Table Data

[Mike]

Hello all, I would like to ask if there is a way to populate multiple fields
on a form with the selection of one attribute. Basically I have a table of
individuals based on salesIDnumbers and I would like for the user to simply
select the salesIDnumber that suits the sales person. I would create that
drop down to display the salesIDnumber along with the sales person's last
name so the user can see who he/she is selecting but I was hoping that once
they select this sales person the rest of the fields (Ex. location, first
name, lastname, etc) would populate with the related record?

 

[Golfinray]

You want to add a combo box to your form. Allow the combo box wizard to do
that for you and set the source of the combo when it asks you to
salesidnumber. Once the combo is created, right click on it to get
properties, go to events, in the afterupdate event start the code builder
(the little button out to the right of that event.) Then type
Me.filter = "[salesidnumber] = """ & Me.combo# & """"
Me.filteron = true
The combo box number will show when you start the code builder, like combo12
or combo21. Now all users will have to do is pull up the list on the combo
box and select and the rest will autopopulate.