HOW TO DO -INPUT FORM WHERE DROP DOWN LISTS OPEN OTHER LISTS TO SE

[tnahowru]

Inputters need to put in their time and select what they worked on, witch can
start out with one type, then tree down to more specific types they must
select.

 

[Arvin Meyer [MVP]]

An example is at:

http://www.accessmvp.com/Arvin/Combo.zip

It uses listboxes but the code is the same.

 

[tnahowru]

There's an error in that database, can you tell me how to fix the error since
i'm using it for a template. the error is in "qryProducts" when you run it.

thank you.

 

[Arvin Meyer [MVP]]

There are no errors. 2 of the 3 queries do expect that the form is open when
they are run. Since the form opens when the database opens, you should never
see the request for a parameter.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[tnahowru]

oh ok sorrrrry, should have known.

There are no errors. 2 of the 3 queries do expect that the form is open when
they are run. Since the form opens when the database opens, you should never
see the request for a parameter.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com