Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I make a form popoulate based on a selection of a combo box?
- Thread starter Kurtosdf
- Start date
braindead2
Technical User
Create an unbound combobox. Name it comboselect
Set its source to the field that holds the students IDs.
In the combo boxes after update event place code like this
dim filttxt as string
filttxt = "Studentid = " & me.comboselect
docmd.applyfilter ,txtselect
If your studentid field is not a number you may have to use
filttxt = "Studentid = '" & me.comboselect & "'"
Set its source to the field that holds the students IDs.
In the combo boxes after update event place code like this
dim filttxt as string
filttxt = "Studentid = " & me.comboselect
docmd.applyfilter ,txtselect
If your studentid field is not a number you may have to use
filttxt = "Studentid = '" & me.comboselect & "'"
- Status
Similar threads
- Locked
- Question
