Macro question (1 Viewer)

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?

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.

I'll get out of the way.

Yep, it was set property. Thanks so much.