Dlookup in form

[soldat452002]

Hello,

I have a question, I want my form frmintake to lookup with values from another table and populare county once the zip codes has been entered.

I have a table called tblintake and another tblcounty.

tblintake has zip codes entered manually

tblcounty has zip codes and counties for all regions

how does this work out in dlookup.

=DLOOKUP[Zip Code],[tblCounty],[zip Code]=[County])

Thanks

 

[John Big Booty]

Perhaps the sample here will give you some pointers. I believe it is doing pretty much what you are after.