<div>
Hi Crystal -- thanks for the direction. Let me give this a shot, but it looks very promising.
</div>


Hi Crystal -- thanks for the direction. Let me give this a shot, but it looks very promising.

<div>
Thanks for the completeness of the solution.....!
</div>


Thanks for the completeness of the solution.....!

<div>
you're welcome ;) ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.
</div>
</div>


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.

MS Access 2013: change form page caption programmatically

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.