I have a form that is shown as a datasheet view when it's loaded. During the loading of the form, I would like for it to do a "calculation" that if the "Refill Date" is greater than the "PA Date", it changes the "PA Required" to TRUE. But I need it to check all the rows as the form loads. I should add that I don't want to save the change to PA Required in the table that stores the data, just want it to show me when the form loads. How can I do this with VBA code?
Thank you in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.