Control Source: Check if a text box in a form exists in a database table.

[joeshig]

Hi,




I have been looking around for a while now but cannot seem to get this question answered.


In access I have a form with a blank text box, in this blank text box I would like it to check whether the contents of another text box (called txtReg) on the same form exists in a database table.

If it does exist, I would like it to show the work 'Covered'.

Is this possible, I've have numerous tries at using DLookup but to no avail?

Thanks

[aytee111]

Dlookup is the right way to go. In the AfterUpdate event of the first textbox, do your DLookup and populate the second text accordingly.

[Bulzie]

Put this code in the OnCurrent event of the form. (Change names of fields and tables below to yours.) Assuming value in txtReg on form is text. If a number look at the link to change the syntax.

If Not Isnull(DLookup("FieldInYourTable", "YourTable", "txtReg = '" & Me.txtReg & "'")) then

Me.YourTextBox = "Covered"

Else

Me.YourTextBox = "Not Covered"

End If


DLoookUp Info:
http://access.mvps.org/access/general/gen0018.htm