Macro question

[rikklaney1]

Hi guys, I have another (probably) stupid question. I have a form with an unbound text box (text6). I want to open this form from a macro and set the value of text6 depending on which macro opened the form.

macro1 text6.value = "rs1"
macro 2 text6.value = "rs2"
etc.
etc.


Is there a way to do this with a standard macro? I have tried using the Where condition in the macro builder but either that's not the way to go or I have the syntax wrong. Here's what I put

Where Condition = [Forms]![process]![Text6]="rs1"


the form still open with text6 blank. Any suggestions?

 

[pbaldy]

Well, the where condition opens the form to a desired record. It sounds like you want an action after the OpenForm action, either SetValue or SetProperty.

 

[arnelgp]

OpenForm
    FormName    yourFormName
    View        Form
    Filter Name
    Where Condition
    Data Mode
    Window Mode    Normal

SelectObject
    Object Type    Form
    Object Name    yourFormName
    In Database Window    No

SetProperty
    Control Name    text6
    Property    Value
    Value        rs1

 

[pbaldy]

I'll get out of the way.

 

[rikklaney1]

Yep, it was set property. Thanks so much.