VBA refer to lookup value (not bound value)

  • Thread starter Thread starter markmarko
  • Start date Start date
M

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!
 
Back
Top