Dlookup

[dgarber]

Wondering if someone can help me figure this out?

I have a table named Games. In the table I have 2 fields which are Game_Number and Game_Name. Each Game_Name corresponds to a specific Game_Number.



I have a form named GameInventoryEntry with a field where I scan a Game_Number and a text box called Game_Name. What I need to have happen is when the Game_Number field is populated with the scan, the Game_Name text box is populated with the corresponding Game_Name.

I am trying to use Dlookup but am lost on how to write the 3rd argument.

Thanks
D

[pbaldy]

You haven't shown your effort, so here's a reference:

http://www.theaccessweb.com/general/gen0018.htm

[dgarber]

I'm not sure what "You haven't shown your effort" means?

[pbaldy]

Your effort at creating a DLookup() that returned your desired information.

[dgarber]

=DLookUp("Game_Name","Games","Game_Number=" &...................is as far as I got.

[pbaldy]

The link should get you the rest of the way.