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
"Nick T" wrote:
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.