I have a Tabbed Form with 8 Tabs I added a text field to the base Form, then added the first name + " " + the last name from the first Tab. The name is shown no matter which Tab that your on and I buttons if you use the block of navigation buttons at the bottom of each tab and move up or down the records the name follows in sync with the records. Now, the problem is I carry dates in the database, (i.e. Birthdays, Wedding dates, or Children's Birthdays). My attempt is to hold the current date on the form base to use in date math so that I can calculate the age of the members. Since these things change as the days pass, I can make it let me know when and who to direct my attention to.
I can do it in MS-EXCEL, but MS-ACCESS is giving me fits.