query

[SusanM]

I have created a menu screen with command button.
purpose is to locate specific person by: year,month,day
and ID#. Have set up parameter queries.
I need this to happen:
1. press command
2. parameters are asked: year, month, day, ID#
3. A specific form should now come up with the specific
employee(ID), yr month and day.
Everything works fine except the last step.
Instead of the form coming up, a table type view comes
up.I need for the form I have created to come up for data
entry. Its not coming up. Sorry for the length of this
question
Thanks everyone for your help.

 

[John Vinson]

I have created a menu screen with command button.
purpose is to locate specific person by: year,month,day
and ID#. Have set up parameter queries.
I need this to happen:
1. press command
2. parameters are asked: year, month, day, ID#
3. A specific form should now come up with the specific
employee(ID), yr month and day.
Everything works fine except the last step.
Instead of the form coming up, a table type view comes
up.I need for the form I have created to come up for data
entry. Its not coming up. Sorry for the length of this
question
Thanks everyone for your help.

Please post your code. It sounds like you're opening a Query - that's
neither necessary nor helpful; instead base your form on the query and
open the Form.

 

[SusanM]

Sorry,do not understand.
I have created a macro for the command button to run the
parameter queries, yr, month, day, employee id. but the
form does not come up. it pulls up a table view.
Any other suggestions. Thanks everyone. you are the best.
SusanM

 

[John Vinson]

Sorry,do not understand.
I have created a macro for the command button to run the
parameter queries, yr, month, day, employee id. but the
form does not come up. it pulls up a table view.
Any other suggestions. Thanks everyone. you are the best.
SusanM

A Macro which runs a parameter query *RUNS THE PARAMETER QUERY*. A
parameter query is *not* a Form!

Your macro should not have a RunQuery action in it at all.

Instead, use the parameter query (a single query, with four parameters
- not four queries as it sounds like you're using) as the Recordsource
of your form; and in the macro, use the OpenForm event to... well...
open the form.