-
It may be that you are trying to upload an Access Database, they have to be in a Zip file to be acceptable.
The way that I achieve what you are trying to do is by using a Query for the second listbox, (although I use combo boxes), the Query has to include the table 2 field that contains the "Building" value from Table 1, ie the field that relates the 2 tables.
Then in that field's Criteria Row in the query you add
Forms![Formname]![combo1name]
You can select the first combo and then run the query and see what list you get, so you can test the output.
All it requires then is to add the following code to the 1st Combo box's "After Update Event Procedure"
me.[combo2name].requery
If you can't get it to work I will create you a simple database.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules