Button Names on a form

[mindbender]

Is there a way when running queries, macros or reports from a button to have the name of the button displayed instead of the object that was run?



For example I have a button titled Revenue that when pushed runs the query XPPS_YTD_Revenue. When the Tab opens it is titled XPPS_YTD_Revenue. Is there a way to get the tab to show the name of the button instead of the underlying object?

Thanks in advance

bret

[June7]

Why do you 'run' that query? Users should not work directly with tables and queries, just forms and reports.

Do not think the tab caption can be altered. I don't use Tabbed Documents style, always change db to Overlapping Windows.

[mindbender]

they are hitting a button on a form that calls an embed macro that calls a query. When the data is returned the tab name (window name) shows the name of the query that was run and not he name of the button that was pressed. I would like it to display the name of the button that was pressed

[Missinglinq]

We understand what you want to do, but I agree with June7, in that I don't think it'd possible. My guess is that your only choices are to

1. Rename your Queries
2. Create Forms, based on your Queries, and name them as you like
3. Modify your Command Buttons to call the Forms, instead of directly calling the Queries

I also agree with June7 in that users really should not work directly with Tables or Queries, but rather through Forms.

Linq ;0)>