Drop Down to list to specific record

[googalabosh]

Here is the basic idea:


Tables-
1) Cars
2) Parts

Query-
Cars linked to Parts

I want to create a form that starts with a drop-down. I would pick the car I want which then shows me a list below it (subform) of all the parts related to that car. Then I want to click on the part in the list and have it show me all the information on that particular part in another subform. How would you do this?

[ranman256]

subform? why not the main form?

1. you can filter the list of all records:

sub cboBox_afterupdate()
if isNull(cboBox) then
   me.filterOn = false
else
   me.filter = "[Field]='" & cboBoxx & "'"
   me.filterOn = true
endif
end sub

or 2, the combo box has 2 columns, 1 Caption, 2, query
Cars, qsCars
Parts, qsParts

Hide column 2, so user only sees the caption.
when user selects the item, use the query (in column 2) to attache to the list (or subform)

sub cboBox_afterupdate()

subform.sourceObject = cboBox

end sub

[June7]

Apply filter criteria to subform Filter property and turn on filter with FilterOn property.

Another option is to synchronize the two subforms. Review https://www.fmsinc.com/MicrosoftAcce...edSubforms.asp