Refresh data in datasheet from

[Freddie81]

So just when I thought i won Acces shovels a new hickup onto my porch.






What I wanted to do:

I have a datasheet with qoutes on it. When I click on the qoute number it opens a new form containing the info from that qoute. If I click on a blank field it opens the form to add new data. What I want is to refrsh the datasheet with the new info when I close the form so I coded a on form close event with Forms!QouteDS.requery which works fine.




The new problem:

I have navigation form as per screenshot. The navigation form runs a form called qoutesF which has th datasheet aas a subform (second screnshot). Now everytime I click on the qoute nr and the new for opens with the record data and I close that frm i get an error that access cannot fid Qoutesds( datasheet form) so it cant requery it.

Any advice on how to get past this issue?

[June7]

Possible options:

1. Click 'Refresh All' on the ribbon

2. VBA code: CommandBars.ExecuteMso "DataRefreshAll"

[Freddie81]

Thank you very much June7..it worked perfectly