MS Access: I have two tables (Table1 and Table2) and a form (Form1) which is bound to the contents of Table1. Form1 has some pages which are labeled. I want to be able to rename each of the page label captions based on values stored in Table2 using SQL (for example, user1 might see one set of captions for pages 1, 2, and 2, where user2 might see another set of captions for the same pages -- the on load event for the form would know the user ID and be able to reference Table2 for the caption values). The page will always have a pre-existing caption to change, so no null values.
I'm guessing DAO is the way to go to get the values but I'm having trouble with the syntax, and also not sure how to marry the value up with the caption-change code.