F
fishqqq
I have a form with a subform in it (subform is a continuous form).
This subform has a list of origins & destinations that any particular
customer will ship between.
What i would like to do is have a drop down box in the form header of
the subform that will show a list of possible destinations and once
the user picks the correct one the subform will show only the records
that belong to that customer that also have that particular
destination.
so far i've be able to get my head around the following:
Step one:
user pics correct destination - this updates [Combo33]
Step two:
subform [Quotes by Customer] (which currently shows every quote for
this customer) needs to have the current filter removed and a new
filter used.
The new filter is a query called [qLookup]
This query is set to grab all the records for this customer that have
the destination that is currently stated in [Combo33]
The question is how do i get the subform to set it's own filter and
refresh?
In my macro i have the after update property of [Combo33] set as
follows:
SetProperty - but there is no property setting for "set filter" or
something like this.
I'm lost at where to go at this stage.
Any suggestions are appreciated.
Tks
This subform has a list of origins & destinations that any particular
customer will ship between.
What i would like to do is have a drop down box in the form header of
the subform that will show a list of possible destinations and once
the user picks the correct one the subform will show only the records
that belong to that customer that also have that particular
destination.
so far i've be able to get my head around the following:
Step one:
user pics correct destination - this updates [Combo33]
Step two:
subform [Quotes by Customer] (which currently shows every quote for
this customer) needs to have the current filter removed and a new
filter used.
The new filter is a query called [qLookup]
This query is set to grab all the records for this customer that have
the destination that is currently stated in [Combo33]
The question is how do i get the subform to set it's own filter and
refresh?
In my macro i have the after update property of [Combo33] set as
follows:
SetProperty - but there is no property setting for "set filter" or
something like this.
I'm lost at where to go at this stage.
Any suggestions are appreciated.
Tks