Auto Refresh

[weircolin]

Hi there

I have a form and a sub form. The main form is used to add an event
to a table and the subform has a combo box that allows the user to
select and event from the table.

When I enter a new event into the form, it doesn't show in the subform
until I close it and then open it again. Is there anyway I can get it
to do this automatically, save button or something?

Cheers

Colin

 

[ruralguy via AccessMonster.com]

If Me.Dirty Then Me.Dirty = False
...will save the current record.

 

[Maverick]

You need to add code to refresh the combobox on the subform. If you place the
following code (replacing YourSubformName and ComboboxName with the
appropriate names) in the AfterUpdate event of the control on your form, it
should work:

Forms!YourSubformName.ComboboxName.Requery

If requery doesn't work, try refresh.

 

[weircolin]

If Me.Dirty Then Me.Dirty = False
..will save the current record.





--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200808/1

Thanks, do I put that behind a command button?

 

[weircolin]

Great, thanks!

 

[Maverick]

Happy to help.

By the way, Allan is way better at this stuff than I am. He has taught me
much of what I know. His way may provide you with a better result in the long
run.

 

[ruralguy via AccessMonster.com]

Post back if you are still having problems. Thanks for the plug Maverick.

 

[Maverick]

You deserve the plug. Not only do you know your stuff, but you are so willing
to help others. I think that is awesome!

It's funny... the two Access gurus I rely on the most are Allan (Bunch) and
Allen (Browne). Is there a running theme here?

 

[Maverick]

Colin,

Please mark the answer that solved your problem as helpful so that others
know that your post was resolved.

Thanks.

 

[weircolin]

Hi

Trying to but using Google Groups and I can't see where to do that...

Colin