VBA refer to lookup value (not bound value)

[markmarko]

Hello,

I need to refer to a bound value's lookup value (in VBA, but also in
expressions).

For example, there are two tables: tblProducts and tblSalesDetails.
tblSalesDetails has a lookup to product names from tblProducts. I want VBA
to check which product was chosen by user by Product Name, not by bound value
(since tbl Products will change over time.)

Is there to reference a bound value's lookup value programatically?

Thanks!

 

[Sreedhar]

Hi,

Please take a look at :

http://www.mvps.org/access/lookupfields.htm

 

[Sreedhar]

Hi,

And also this:

http://allenbrowne.com/casu-07.html