Started a new job with the most recent version of Access and can't find an answer to this -
When doing a basic Update query linking two tables I want to update a field in Table 1 to a field in Table 2 - every version I've had for the past 20 years gives you a drop down menu of the table fields available in the "Update to:" line but not this version?? I can type it out of course but I miss my drop down menu. Any ideas how to get this back?
Part of me thinks I've totally lost my marbles and it was never there to begin with - but it was!
Thanks in advance for any help.
When doing a basic Update query linking two tables I want to update a field in Table 1 to a field in Table 2 - every version I've had for the past 20 years gives you a drop down menu of the table fields available in the "Update to:" line but not this version?? I can type it out of course but I miss my drop down menu. Any ideas how to get this back?
Part of me thinks I've totally lost my marbles and it was never there to begin with - but it was!
Thanks in advance for any help.