Set filter on a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set the filter on a subform after the user updates a value on the
main form. For instance, when the user chooses a customer on the main form,
I'd like the subform to display transactions by that customer. Problem is, I
have to consolidate several customers (ie. JoeDiner-West, JoeDiner-East) who
have separate Customer IDs. Therefore, I think I need to do this in VB in
the after event of the "choose customer" control.

Any suggestions?

TIA
 
how about adding a MainCustomer Field to the table with a selfjoin between
This & CustomerID?
Then you could consilidate using this field instead

HTH

Pieter

Francophone said:
How can I set the filter on a subform after the user updates a value on
the
main form. For instance, when the user chooses a customer on the main
form,
I'd like the subform to display transactions by that customer. Problem
is, I
have to consolidate several customers (ie. JoeDiner-West, JoeDiner-East)
who
have separate Customer IDs. Therefore, I think I need to do this in VB in
the after event of the "choose customer" control.

Any suggestions?

TIA
Click to expand...



--
 
You must log in or register to reply here.

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

Similar Threads

Subform Data Entry Setting 0
Sync Main Form with Subform after Combo Selection 2
subform filter 7
Access Daily Entry with multiple entries per field 0
1)VB code or Wizard? 2) Subform or filter? 3)combo box problem 5
2 subforms on 1 form 1
subform combo to filter based on other subform...technically mainform's other subform records. 0
Filtering Subform using option buttons on main form 3

Back
Top