From: buzzmcduffie on
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!
From: fredg on
On Wed, 21 Apr 2010 17:29:01 -0700, buzzmcduffie wrote:

> 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: buzzmcduffie on
I'll check out the vba help

"fredg" wrote:

> On Wed, 21 Apr 2010 17:29:01 -0700, buzzmcduffie wrote:
>
> > 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.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
> .
>