Datasheet form refresh issue

[GoodyGoody]

Hi, I'm new to Access (but not coding) and have a datasheet which is just populated from a table. I have put a macro behind the 'ID' field so the user can click the ID field and it runs the Macro to bring up eitther a New Record or to edit the existing record. When I click the 'New' link and add a record, despite having used the 'Refresh' command in the Macro it doesn't the new record to the visible list. I also tried the Requery command but that doesn't seem to help either. There's a 'Refresh All' option on the menu bar which does do the trick so can someone tell me what the Macro version of 'Refresh All' is please? many thanks
Stephen

 

[theDBguy]

Hi. Are you saying the macro is calling a popup form? Is this from one of the available MS Templates?


Can you post a screenshot of your macro for us? Thanks.

 

[Gasman]

Did you try the Requery *without* any argument ?

 

[GoodyGoody]

Thanks for asking and yes.

 

[Gasman]

Not sure what to say.
I just created a datasheet form.
I created a form for data entry.
I created a macro with the follwoing steps

Open form to add a new record in dialog mode
Close form, though I did close it with the X
Requery on it's own

I ran this query from a double click of the ID control on the table and the new data appears as I would expect.?

HTH

 

[GoodyGoody]

I was running both Refresh and ReQuery and they seem to interfere with each other. Just Requery on its own works a treat so thank you for checking.

 

[theDBguy]

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[GoodyGoody]

Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no avail. Very odd...

 

[theDBguy]

Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no avail. Very odd...

Have you seen this?

 

[GoodyGoody]

...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed.

 

[theDBguy]

...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed.

Downloading and updating what? The fix is to "unistall" the MS update.

 

[GoodyGoody]

Ah right! Doh!

 

[GoodyGoody]

Sorted. Thanks again

 

[theDBguy]

Sorted. Thanks again

Hi. Glad to hear you got it sorted out. Don't forget to turn off automatic updates until after Dec 10.

 

[GoodyGoody]

Good point. Thanks for the reminder.

 

[theDBguy]

Good point. Thanks for the reminder.

No worries. Good luck!