Query Caption header, is it possible

[azzi2000]

I have a form that has a button to excecute a smple query.
Can I control the query caption table: It display
<Query Name>: Select Query
How can I control the display if possible.
Please advice,
Thank you.
Dré

 

[PHV]

How can I control the display
By using a form bound to this query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[azzi2000]

PHV:
Thank you.
Dré

 

[azzi2000]

PHV:
On the related subject I created a form bound to query.
When I click on the form it will display in a datasheet form however when I placed it in a button to open a form it will diplay one record at a time.
How can I have it diaplyed in a datasheet mode.
Please advice,
Thank you.
Dré

 

[PHV]

Take a look at the 2nd argument of the DoCmd.OpenForm method:
DoCmd.OpenForm "your form name", acFormDS

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[azzi2000]

Thank you.
Dre