code on text box

[Nick T]

Hi,

Any suggestions on code which would work for the following:
I have two text boxes - "TextA" & "TextB". can i put some code some where
which will carry out a set function eg. close my db.

ie, When "TextA" = "TextB" Me.Application.CloseCurrentDatabase

???any suggestions

Basically, when one text box equals another text box, my database closes??
Where would i put the code and any suggestions what code i could try.

Any suggestions greatly appreciated.

 

[S.Clark]

In the AfterUpdate of both of the textboxes call a proc like: IsValidToClose()

Sub IsValidToClose()
If me.txtA & "" = me.txtB & "" then
Me.Application.CloseCurrentDatabase
end if
End Sub

It won't be as simple as this, because you'll encounter a few issues, like
forms closing in an updated state, so you'll just have to figure out the
little inconvienances. But focus on the principle of it.

The & "" is to avoid having errors with Null values.

Steve Clark
Access MVP '00-'05
Twin Soft
www.twin-soft.com