Form queries

[dksj67 via AccessMonster.com]

I would like to create a form and a report based on PARAMETERS selected by
user. Because there are 583 possible selections I would like to make it easy
for the user to drill down to the correct parameter value. I created a form
with a combo box that has a row source that is a query that returns possible
"Building Number" values. I would like to provide another combo box whose
possible selections are based on another query with the value of the first
combo box as the input parameter. I cant seem to get it to work:

In the Row Source property of the second combo box I typed:
SELECT Panels.[Panel Name] FROM Panels WHERE (((Panels.[Panel Building Number]
)=Forms!PanelLocations!Combo30));

Why does this not work and how can I get the form to do what I want it to do?

Dan Kreiling

 

[Ken Sheridan]

Dan:

You need to requery the second combo box in the AfterUpdate event procedure
of the first:

Me.[YourSecondComboBox].Requery

Ken Sheridan
Stafford, England

 

[dksj67 via AccessMonster.com]

Thanks Ken, worked like a charm!

Dan

Dan:

You need to requery the second combo box in the AfterUpdate event procedure
of the first:

Me.[YourSecondComboBox].Requery

Ken Sheridan
Stafford, England

I would like to create a form and a report based on PARAMETERS selected by
user. Because there are 583 possible selections I would like to make it easy

[quoted text clipped - 11 lines]

Dan Kreiling