Command Bars - Form Open Args 1

[SeeThru]

Hi All

Trying to open a form from a command bar, but using some sort of argument. OpenArgs does not seem to be available. I tried using the Tag property of the button, but cannot find a way to refer to it.

Can I either use openargs, or get the name of the calling button?

The only other option is to create three copeis of the form, but that seems....inelegant.

Thanks for any suggestions


SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk

 

[TheAceMan1]

How are ya SeeThru . . .

You need to call your own function (with supplied arguement for [blue]OpenArgs[/blue]) in a module from the [blue]On Action[/blue] property of a button on the commandbar.

Special Note: Although you can edit the [blue]On Action[/blue] property of system supplied buttons, its better if you customize your own.

As an example, say you have the following function in a module in the modules window:

[blue]Public Function OpnFrm([b]Arg[/b] As String)
   DoCmd.OpenForm "[purple][B][I]FormName[/I][/B][/purple]", , , , , , [b]Arg[/b]
End Function[/blue]

To run the function, a call from the [blue]On Action[/blue] property of a command button would look like:

[blue]   =OpnFrm("[purple][B][I]OpenArgsTextHere[/I][/B][/purple]")[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SeeThru]

Looks like it should do it - thanks!

SeeThru
Synergy Connections Ltd - Telemarketing Services