Pop Up Dilemma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a grid containing recs on it. When a user selects a
record
in this grid a maint form appears so they can edit the record. This maint
form has the properties popup = y, modal = n because I want them to be able
to move the maint screen around and see the recs in the grid in the form
underneath, and maybe interact with it while maint screen up (i.e. resort
recs in grid). In any case, once they update the rec in the maint form, the
user is brought back to the form with the grid in it but I can't figure out
how to refresh the recs in the grid with the newly updated data (the activate
event does not get executed). I've tried everything I could think of but
add a refresh button. Any suggestions would be greatly appreciated.
Jackie
 
Jackie,

Take a look at the following web page:
http://www.pacificdb.com.au/MVP/Code/MyDialog.htm

Create a public event (maybe called RefreshGrid) in the maint form, and have
code in the maint form raise the event when appropriate.

In the grid form, instantiate the maint form using the WithEvents keyword.
As with any other form event, sink the maint form's custom event
(RefreshGrid) in the grid form's module.

Then when the event fires, update the grid.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Graham

Thanks for the info. Wasn't exactly the solution that I was looking for but
pointed me in the right direction and I was able to get it to work. Your
quick response was much appreciated.

Jackie
 
I've been trying to do the same thing, but haven't hit upon the solution. How
did you finally resolve this? I'd appreciate your sharing!
 
Back
Top