I'm sure my answer is here somewhere in the forum, but I'll be darned if I can find it with various keyword searches.
I have an MS Access 2013 database I have inherited that has significant existing reports, tables, forms and queries.
As a result, I'm reluctant to make significant changes since it seems things are working, but I need to add some values in a table.
In the table "tblX" I want one field ("fldX") to obtain its value from an existing query ("qryY") based on a field common to both ("fldY").
I have created a Lookup in fldX, and I can get the value using a combobox ONE time, but if the value in qryX changes, the value in the tblX fldX lookup does not update.
So, basically I want fldX to reflect the value in fldY of qryY, and to be "hot-linked" so if the value in qryY changes, the value in tblX fldX updates automatically.
Surely possible within a lookup query tblX, but I'm missing something...
Thanks in advance!