Compare the text field to table field (1 Viewer)

[Gemma Khan]

Hi,
How to compare the text field to Table fields?

Thanks

 

[Galaxiom]

The text field on the form can be referred to by its name.
From the form's Class Module:

Me!controlname

Use a Domain Lookup for the table field.

DLookUp("wantedfieldname","tablename","somefield.tablename=Forms!formname.somecontrolname")

 

[Max D]

If you need to compare text field on form to some current record field, you can reach them by their names.

Lets assume you have:

• Table1 with (ID,Full Name) fields
• form tied to Table1, but without the textbox bound to Full Name field
• unbound textbox named Txt

You can write something like this:

If [COLOR=RoyalBlue]Txt[/COLOR]=[COLOR=RoyalBlue]Full_Name[/COLOR] Then la-la-la...