Help With Yes/No and Reminder of Changing Dates

[bwedmund]

Please tell me how I can place a statement with a yes/no statement on a form so that when a person responds "yes" the form will return to a switchboard, or if they say "no", the form remains the same.

I can not remember to change dates on the form. Is there a way to make to program ask you to change the date? This is done using Access 97.

The following was sent to me to use and I keep getting errors when it is in use. I also got an access 97 reference manual and I am still having problems.

I am not famalier with programming so any help would be appreciated.
private sub yesnofield after_update()
if me.yesnofield = false then
exit sub
else
msgbox"change the date"
me.form.switchboard.gotfocus
end if
end sub

I am not famalier with programming so any help would be appreciated.

 

[DougP]

If Me!YesNofield = False Then
Exit Sub
Else
DoCmd.OpenForm "switchboardformname"
End If

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.