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.

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.
>