Refreshing subform when form refreshed

[RuralGuy]

As for dispensing with the 'refresh' button, are you talking about adding an AfterUpdate event or something like that?

Absolutely! If the user is interacting with the form in any way, there are several events taking place that can do the refresh for you. FYI...do you know what the difference is between Refresh and Requery?

[Remster]

FYI...do you know what the difference is between Refresh and Requery?

Not a clue. All I know is that when I substituted 'Requery' for 'Refresh' in my code, my 'refresh' button didn't update my dropdowns. Instead it took me to the first record.

[RuralGuy]

Refresh only updates the current Recordset while a Requery get an entirely new Recordset. This means that Refresh will not drop deleted record (usually shows Deleted) nor will it show any new records. A Requery will get a new Recordset so new records will be present and deleted records will be missing and you are taken back to the first record of the recordset.

[Remster]

The main problem is that 'Requery' doesn't seem to work. With reference to my earlier screenshot, if I enter a new record into the subform and click the refresh button, the new value doesn't appear in my dropdown lists. (The other problem is that I don't want to return to the first record!) Perhaps simply replacing 'Refresh' with 'Requery' in my VBA isn't enough.

[RuralGuy]

Maybe this link will help: http://www.baldyweb.com/Requery.htm

[Remster]

Thanks, I'll try to look at that at the weekend. Unfortunately I don't have access to a PC that both can handle zip files and has Access installed, to I'll pick the files up at someone else's house.

[RuralGuy]

Are you using Windows? XP knows how to unzip a file. There are also Free utilities that can UnZip: http://download.cnet.com/FreeZip/3000-2250_4-9507.html

[Remster]

If only it were that simple! I have XP at work but zip files are blocked. I have 98(!) at home but no internet. And my parents have Vista but no MS Access. So I'm going to unzip the sample database at my parents' house, put it on a memory stick, and take it home.

[RuralGuy]

Sounds like you have a plan. Go for it!

[Remster]

I know this will make you want to beat me up, but I still can't get 'Requery' to work, whereas 'Refresh' seems to do what I want it to do: it adds any new records to my lists and removes any deleted ones.

[RuralGuy]

Well if it is working than I would say it is not broke. Are we done here? 8^)

[Remster]

Yep – I've duly marked it solved.

[RuralGuy]

Great. Enjoy the rest of the day.