Linking forms

[Shawn]

I have one form that includes a Transaction Type and I'd
like to have a formula in that field that basically
says "if this field is "default" then open up this form".
Is there a way that I can do this?

 

[Jonathan Parminter]

-----Original Message-----
I have one form that includes a Transaction Type and I'd
like to have a formula in that field that basically
says "if this field is "default" then open up this form".
Is there a way that I can do this?
.

Hi Shawn,

can you please clarify the following...
Are you using 2 forms? That is, as you move from one
record to another, a field, transaction type may
display "default". When it does then open a second form.

If this is the situation then use the form_OnCurrent()
event (this event is triggered when the form first opens
to the first record and whenever you navigate to another
record). Use the following as an example (air code)...

private sub form_oncurrent()
if lcase(txtTransactionType)="default" then
docmd.openform FormName:="myForm", WindowMode:=acDialog
end if
end sub

Luck
Jonathan