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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Filtering a subform based on combo list selection
Ok, just after reviewing my own posts I can see one big error is that I used Supplier, which is not even a table or anything in my database. I think something like [Forms]![User]![Furniture subform] should be there instead.. something like... Private Sub cboEmployee_AfterUpdate()...- thehhwy
- Post #3
- Forum: Microsoft: Access Forms
-
Filtering a subform based on combo list selection
I tried the code below, but got an Object Required error I think [Employee] should be something else, Private Sub cboEmployee_AfterUpdate() Supplier.Form.Filter = "[Employee]= '" & cboEmployee & "'" Supplier.Form.FilterOn = True End Sub For more clarification: My User...- thehhwy
- Post #2
- Forum: Microsoft: Access Forms
-
Filtering a subform based on combo list selection
Hey guys, I took a look at this site and found it to be very useful. I am a beginner in MS Access but what I am trying to do should be very simple. So we have a User table and a Furniture table, and the Furniture table has the columns FurnitureIDNumber, FurnitureType and AssignedTo. The name...- thehhwy
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
