Rowsource Equivalent

[Guest]

In a listbox or combo box, I can use a SELECT query to populate it based on
information entered in certain fields. Is there an equivalent for something
like this for a texbox? Can I use a SELECT statment in a texbox Control
Source or something like that? Thanks.
ck

 

[Guest]

Put it in the Default Value.

 

[John Vinson]

In a listbox or combo box, I can use a SELECT query to populate it based on
information entered in certain fields. Is there an equivalent for something
like this for a texbox? Can I use a SELECT statment in a texbox Control
Source or something like that? Thanks.
ck

The closest thing would be a DLookUp() function call. The field won't
be editable. Could you explain what you're trying to do with this?

John W. Vinson[MVP]

 

[Guest]

What I'm trying to do is that as the user enters the building number and post
code of the address, the field will display the family ID that has a record
that matches the address just entered.
ck

 

[Guest]

Thanks John, DLookup() is exactly what I'm looking for...
ck