Current Record Showing Up

  • Thread starter open a adobe file from a command button
  • 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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top