Bind Value List to Subform?

[karmadog]

Hello Access Guru's!


I'm trying to create an Access application that will help me manage various interior signage in several different building complexes. I've created dynamic dropdown lists that filter down to a specific floor section. Each floor has a set of similar signage types, i.e. Office, Conference, Breakroom, etc. I want to be able to drill down to a specific building campus->building->floor->section and then see a list of the different sign types specific to that area. I then want to double-click a sign type from the list and have it open a subform that displays all the signage meta-data, like Manufacturer, size, placement location, etc.

The problem is that all the sign types are the same, so when I double-click a sign type from the main form list, it seems to open the first instance of that sign type regardless of it's location.

How do I bind a similar sign type to the specific location is occurs?

Hope this makes sense! I've included a couple of pics that may help.

Thanks!
Mark in Austin

[June7]

Signs don't have a unique identifier?

If you want to provide db for analysis, follow instructions at bottom of my post.

[karmadog]

Here you go. FYI, I'm converting an existing database I wrote last year for auditing fire extinguishers in the same campuses.

[June7]

If I understand, want to open frmFieldData filtered to a specific sign.

Need LabelID in the Signage listbox RowSource.

Then open form with:

DoCmd.OpenForm "frmFieldData", , , "LabelID=" & Me.lstLabelID

I would make one form serve all 3 purposes - add, edit, filter.

Advise no special characters in naming convention - such as the ? mark in field names.

Electrical has been misspelled as Electerical.

[karmadog]

Thank you, June7! I'll let you know how it works out.