refresh unbound form

[MykH]

I have an unbound form that has text boxes and option groups(radio btns). Anyone know the best method of refreshing the form or clearing the entered data after saving the record..? I'd basically like for the user to see a new record after each save..?


Thx in advance

Myk

 

[BanditWk]

The "Requery" command works pretty nice. Also, I believe there's a "Refresh" command.

HTH Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."

 

[MykH]

I actually tried both. neither seemed to work tho'... any examples of how if should be coded..?

 

[lynnd]

If your form is initialized to a new record when it is first opened, you could just include code to re-open the form after a save.

DoCmd.Echo False 'this turns off screen repainting so the user won't see the close and open
DoCmd.Close
DoCmd.OpenForm "MyFormName"
DoCmd.Echo True 'be sure to handle any errors that occur before this point so that you are always sure to turn the screen repainting back on

Good luck,
Lynn

 

[MykH]

Thanks for the help Lynn... worked PERFECTLY!


Myk