dlookup using several fields

[buzzmcduffie]

I have a field on a form that needs to automatically populate by matching 5
different fields in a table. any help will be appreciated!

 

[fredg]

I have a field on a form that needs to automatically populate by matching 5
different fields in a table. any help will be appreciated!

You've asked a very generic question. There is no point in giving you
information that doesn't meet you needs.
If you want specific help you'll have to give us more information,
such as the field names and datatypes that are to be used in the where
clause argument.
By the way, this information is readily available in VBA help.
See:
"Restrict data to a subset of records" + "Multiple Fields in Criteria
Expressions"
But it all starts with the criteria field datatype.

 

[buzzmcduffie]

I'll check out the vba help

You've asked a very generic question. There is no point in giving you
information that doesn't meet you needs.
If you want specific help you'll have to give us more information,
such as the field names and datatypes that are to be used in the where
clause argument.
By the way, this information is readily available in VBA help.
See:
"Restrict data to a subset of records" + "Multiple Fields in Criteria
Expressions"
But it all starts with the criteria field datatype.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.