C
Chad
I have a database setup with several tables of contacts and a primary table
of vendors. I have one form that has an unbound combobox to select the
vendor number. All of the tables are linked through a autonumbering primary
vendorID (diff from vendor number). I have the main form and six subforms
linked on vendorID. All of the subforms are based on queries that include
vendorID and are based on 1 table. I have the subforms requery after
updating the combobox with the vendor number. The subforms only populate
for the first record in my primary table. When I select any other vendor all
of the subforms are blank. If I open the subform alone outside of the main
form it works fine. I can't figure out what is wrong. I suspect it's
something with the master/child relationship not working, but I'm not sure
what I've done wrong.
Thanks in advance for your help!
of vendors. I have one form that has an unbound combobox to select the
vendor number. All of the tables are linked through a autonumbering primary
vendorID (diff from vendor number). I have the main form and six subforms
linked on vendorID. All of the subforms are based on queries that include
vendorID and are based on 1 table. I have the subforms requery after
updating the combobox with the vendor number. The subforms only populate
for the first record in my primary table. When I select any other vendor all
of the subforms are blank. If I open the subform alone outside of the main
form it works fine. I can't figure out what is wrong. I suspect it's
something with the master/child relationship not working, but I'm not sure
what I've done wrong.
Thanks in advance for your help!