K
k.roberts
There are two parts to my question:
Firstly I have created a parameter query which asks for an insitution
code, then brings forward the contact details for that insitution.
This query works fine except the prompt box pops up twice before
actually displaying the information requested. Can anyone tell me why
this happens?
Secondly, I would like to have a command button on a form that will run
this query i.e. when you click the command button, the prompt for the
query comes up and then displays the requested information in a form.
How do I do this? I have attached a macro to the OnClick property of
the button which runs the query, but this displays it in datasheet
view. Help!
Firstly I have created a parameter query which asks for an insitution
code, then brings forward the contact details for that insitution.
This query works fine except the prompt box pops up twice before
actually displaying the information requested. Can anyone tell me why
this happens?
Secondly, I would like to have a command button on a form that will run
this query i.e. when you click the command button, the prompt for the
query comes up and then displays the requested information in a form.
How do I do this? I have attached a macro to the OnClick property of
the button which runs the query, but this displays it in datasheet
view. Help!