Table/Query corresponding row value

[soupisgood84]

Is there a way to get the value of a cell on a specific row by looking up or querying another value on the same row?
Example:
Barcode is a field/column; Serial Number is a field/column.
::::You enter or scan the barcode and the value from the Serial Number field appears in an unbound txtbox.

 

[gwinn7]

Yes.

LOL

Gary
gwinn7

 

[soupisgood84]

...Helpful........
Would you care to share it with me?

 

[gwinn7]

Methods...

1. Use DLOOKUP (see Access Help)

myvalue = DLOOKUP("mycolumn", "mytable", "myid = " & myval)

2. Open Recordset

set rs = currentdb.openrecordset("SELECT mycolumn FROM mytable WHERE myid = " & myval, dbopenforwardonly)

Gary
gwinn7

 

[soupisgood84]

I thought of the Dlookup method, but that will only return the value that you tell it to search, right?

 

[gwinn7]

Yes.

This is a fairly simple question that can be easily answered more thoroughly by viewing the Help. Its a very quick lookup and there should be at least one example of its usage.

This forum is primarily for helping with specific problems that MAY not be easily answered through simple help lookups.

Gary
gwinn7

 

[soupisgood84]

Thanks!