If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
code on text box
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. |
#2
|
|||
|
|||
code on text box
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. |
Thread Tools | |
Display Modes | |
|
|