Assign value to field on loading database..

[sbooth]

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?

 

[RuralGuy]

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.

 

[sbooth]

Thank RuralGuy. It worked great.

 

[RuralGuy]

Excellent! Glad I could help.