Command button on form a to perform function on form b

[UserX]

What I'm trying to accomplish is either:



1. Modify the vb button text; or
2. Create a form that mimics the vb message box

On Transmittal_Log1, the button under the label "Clear" has the vbYesNo message box. I have made the necessary code adjustments to accomplish the tasks I want to happen, but I would prefer the message box button text to be: Clear "Sent" and Clear "Conf", respectively. I read on another forum of a Class module capable of doing this, but couldn't figure out how to call the sub routine within the Class.

As an alternative to above, I tried creating a form with two buttons, with the desired text on the buttons, but for the life of me I can't figure out how (if at all possible) to make the on click event for 'Clear "Sent"' point back to Transmittal_Log1, and then make this happen:

Me.GraphicStatusID = conClearWhite
    Me.Date_Fwd_to_PPSO = Null
    DoCmd.RunCommand acCmdSaveRecord

and likewise for 'Clear "Conf"'

Me.GraphicStatusID = conSentYellow
    Me.Date_JPPSO_Rcvd = Null
    DoCmd.RunCommand acCmdSaveRecord

Thoughts?

[June7]

Remove Me from each of the lines in the Form1 code:

Forms!Transmittal_Log1Me.GraphicStatusID = conClearWhite

should be

Forms!Transmittal_Log1.GraphicStatusID = conClearWhite

[UserX]

June7,

As always, you've been a great help. Removing "me" certainly did the trick. I truly appreciate your assistance. Is there a way around having to spread rep points? Meaning, since as of late, you've been the only one answering my posts, and helping me with my dbs, you should be the one to get the rep points.

[June7]

Rep points not really a big deal, not like I win a sweeps or something - it's an indicator to other readers for reliability of advice and feedback to me.

[UserX]

June7,

I'm sorry, one more thing on the matter... The 'conf' button, when clicked doesn't work the way I had hoped. Although the date is removed from the proper location, the first line of the code:

<code>Forms!Transmittal_Log1.GraphicStatusID = conSentYellow</code>

does not change the GraphicStatus textbox to yellow. Instead, the box goes white. You think you could help me get GraphicStatus to change to yellow as if I had clicked on the "S" button on the Transmittal_Log1 form?

[June7]

Unless you need more than 3 rules for conditional formatting, should be able to use Conditional Formatting without the ApplyCondFormatting() procedure. (BTW, Access 2010 increased the number of rules to 50.)

The code only affects the current record. Shouldn't every record show coloring if meet condition?

I think what you need to do is use the value of some field in the Conditional Formatting rule, such as the GraphicStatusID field.
Right now the rule uses an expression I've never seen: "[cmdSent]_Click"=True

[UserX]

Thanks! Changed all references of yellow to vbYellow, and voila.

[June7]

Ooops, looks like you read my post before major edits.

Oh well, if you are happy with results...