Best Practice: How to Ensure Forms Dependent on Other Forms are Refreshed

[whdyck]

I'm using MS Access 2003.

I have several forms that have functionality that can change depending on what happens in other forms. My question is this: What is the best way to ensure that a given open form is current when it becomes active, given that its data might have been changed by another form.

Does it make sense to simply do a Me.Refresh whenever the form is Activated or becomes current? (I suppose I would want to do this only if the record is not a new record, though.)

Any advice on this would be greatly appreciated.

Wayne

 

[plog]

I just close all inactive forms and re-open them if they are needed again. This makes sure they open with the most current data. My databases open to the Main Menu, if a user clicks a control to open another form, the Main Menu closes, then the form they requested opens. If they want back to the main menu, they click that control which closes the current form and then opens the main menu. Whenever you open a form, close the current one so that the user can only have one open at a time.

 

[whdyck]

Makes sense.

However, some of my forms are Continuous forms listing many records with only a partial set of columns. On each record I have a button they can click to open up the record in a single-record form so they can see more fields. When the user is finished viewing or editing the single-record form, it would be nicer if the multi-record form reappeared when the single-record form closed.

I have code that checks whether a given form is open. I can run that code when I close the single-record form and do a Refresh on the multi-record form at that time.

However, I wondered whether there was a better way of doing it.

Thanks.

Wayne