Current Record Showing Up

  • Thread starter Thread starter open a adobe file from a command button
  • Start date Start date
O

open a adobe file from a command button

I have 3 tables, Vendor,Departments, & Person. I have a 1 to many
relationship between Vendor and Departments, and a 1 to many relationship
between Departments & Person. I used the wizard to create a form to input
data. ‘Vendor Name’ in the vendor table is a text field, I changed it on the
form to a combo box. My thinking is that when I change from one vendor to
another the records in both the departments & people table change, but it
doesn’t. Can someone tell me what I’m doing wrong?

Thanks
 
Your combo box is bound to a field in a record. When you change it your are
changing the stored value.
You need the combo separate to be criteria for the query feeding the form.
Then you need an AfterUpdate event to refresh the query when you want to see
a different vendor.
 
Back
Top