Parameter query for a combo box using form field only works first

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

Guest

I have a combo box with a query as data source. The query uses a parameter
that is also a combo box on the same form.
When I first open the form the query works fine using the ap[pripriate value
from the combo box above, but when I subsequently change the parameter combo
box and then retry to populate the combo box with the query it's not pulling
in the new parameter value - do I need to refresh the form somehow? How could
I do that?

This is the record source for my combo box:

SELECT tblUWLookup.Underwriter
FROM tblUWLookup
WHERE (((tblUWLookup.Region)=[Forms]![frmPolicyInfo]![Region]))
ORDER BY tblUWLookup.Underwriter;


JHM
 
JHM said:
I have a combo box with a query as data source. The query uses a parameter
that is also a combo box on the same form.
When I first open the form the query works fine using the ap[pripriate
value
from the combo box above, but when I subsequently change the parameter
combo
box and then retry to populate the combo box with the query it's not
pulling
in the new parameter value - do I need to refresh the form somehow? How
could
I do that?

This is the record source for my combo box:

SELECT tblUWLookup.Underwriter
FROM tblUWLookup
WHERE (((tblUWLookup.Region)=[Forms]![frmPolicyInfo]![Region]))
ORDER BY tblUWLookup.Underwriter;


JHM
Click to expand...

The combo based on the query is what needs to be refreshed. Say it's called
Combo1 :

Me.Combo1.ReQuery
 
Oh, thanks, that makes sense, should this code be a 'before update' event of
the combo that has the query?
--
JHM


Stuart McCall said:
JHM said:
I have a combo box with a query as data source. The query uses a parameter
that is also a combo box on the same form.
When I first open the form the query works fine using the ap[pripriate
value
from the combo box above, but when I subsequently change the parameter
combo
box and then retry to populate the combo box with the query it's not
pulling
in the new parameter value - do I need to refresh the form somehow? How
could
I do that?

This is the record source for my combo box:

SELECT tblUWLookup.Underwriter
FROM tblUWLookup
WHERE (((tblUWLookup.Region)=[Forms]![frmPolicyInfo]![Region]))
ORDER BY tblUWLookup.Underwriter;


JHM
Click to expand...

The combo based on the query is what needs to be refreshed. Say it's called
Combo1 :

Me.Combo1.ReQuery
Click to expand...
 
JHM said:
Oh, thanks, that makes sense, should this code be a 'before update' event
of
the combo that has the query?
--
JHM


Stuart McCall said:
JHM said:
I have a combo box with a query as data source. The query uses a
parameter
that is also a combo box on the same form.
When I first open the form the query works fine using the ap[pripriate
value
from the combo box above, but when I subsequently change the parameter
combo
box and then retry to populate the combo box with the query it's not
pulling
in the new parameter value - do I need to refresh the form somehow? How
could
I do that?

This is the record source for my combo box:

SELECT tblUWLookup.Underwriter
FROM tblUWLookup
WHERE (((tblUWLookup.Region)=[Forms]![frmPolicyInfo]![Region]))
ORDER BY tblUWLookup.Underwriter;


JHM
Click to expand...

The combo based on the query is what needs to be refreshed. Say it's
called
Combo1 :

Me.Combo1.ReQuery
Click to expand...
Click to expand...

No, use the AfterUpdate event of the parameter combo. Sorry, I should have
mentioned that in my previous.
 
Back
Top