I have tblShow that has ShowStatusNum_fk. Possible values for this are 1, 2, or 3. What I would like to do is on loading the database...

If ShowStatusNum_fk=1 leave it as 1
If ShowStatusNum_fk=2 change it to 3
If ShowStatusNum_fk=3 leave it as 3

Does anyone have any ideas?

I load an invisible form (actually my Kick 'em off form) first and use the Open, Load, Close and Unload events for housekeeping chores such as you have described.

Thank RuralGuy. It worked great.

Excellent! Glad I could help.