Lookup

[Cyberwolf]

I have a form where I enter a line number that may or may not match the
primary key in another table. My question is how do I go about
populating some fields in my form when the record exists in the table?
I was thinking a dlookup but am unfamiliar whith this function and was
not sure how it works. Then I thought to base my form on a query but
then I won't be able to populte the fields if they are null.

Any help would be greatly appreciated.

Cyberwolf

[pietlinden@hotmail.com]

Re: Lookup


Cyberwolf wrote:

I have a form where I enter a line number that may or may not match the
primary key in another table. My question is how do I go about
populating some fields in my form when the record exists in the table?
I was thinking a dlookup but am unfamiliar whith this function and was
not sure how it works. Then I thought to base my form on a query but
then I won't be able to populte the fields if they are null.
>
Any help would be greatly appreciated.
>
Cyberwolf

You mean by using DCount? basically check if the record exists by
using DCount and then performing some action if it does? (like running
an action query of some type?)