PROCV (Excel): What is the same function for Access? (1 Viewer)

[brunces]

VLookUp (Excel): What is the same function for Access?

Hello, Fellas.

Please, anybody knows how I can use VLookUp (Excel) in Access? I mean, is there any function for Access which works the same as VLookUp for Excel?

I have this form and there's a field in it which contains a dropdown. When I choose an item from the dropdown, I want Access to look for the value I chose in the appropriate table, returning the equivalent value from the second column, inside a text box (in the same form).

How can I do that? I'd like not to use VBA, but if there's no other way, that's OK.

I thank for the attention.

Hugz.

Bruno

 

[WayneRyan]

Bruno,

You need the DLookUp function. Use the Search Facility here and enter
"DLookUp", you'll find lots of samples.

Wayne

 

[Pat Hartman]

DLookup() is a possible solution but it does not operate exactly as the Excel VLookup() so make sure you read the help entry carefully.

I would never use a DLookup() in this situation though. The technically "correct" solution is to base the form on a query that joins the main table to the "lookup" table. We spend a lot of time normalizing our databases and don't always explain how to turn that normalized "data" back into "information".

 

[brunces]

Thanx.

Thank you, guys.

I'm gonna check it out.

Bruno