how can I reload a form after update?

[aqm]

hi,
how can i reload a form after updating of the fields? because i loaded a form, but after updating the forms, it gives me problems, the field just don´t display.
anyone to help?
aqm

 

[madhouse]

How are you updating the fields? Have you got a command button that when clicked updates the record in a table?

 

[aqm]

hi,
in the runtime iam updating a table linked to a subforms. the subform is on the main form. how can i make that data appear on the subform without exiting the forms?
how can put in code shift+F9?
thanks.
aqm

 

[Guest_imported]

For the Shift-F9, look at the SendKeys command in access help topics.

 

[Guest_imported]

For the "Update" problem, you have 2 options.
Either
1. In the on-timer event of the form, enter a requery and refresh eg:

Private Sub Form_Timer()

Me.Requery
Me.Refresh

End Sub
OR
2. Ensure that the Requery and Refresh commands are executed following any changes (Eg. in the AfterUpdate event) of all controls on the form.

PS. Ensure that you test the system before it goes live. these problems (if not resolved early) can cause big headaches later on in the development process.

Hope this helps.
Nick.

 

[aqm]

hi,
i need the code of shift+f9. how can i do this command in code?
aqm.

 

[Guest_imported]

For the Shift-F9, look at the SendKeys command in access help topics.

 

[aqm]

i don´t want it to be a command button. i want to put in in code so that the user will not need to press any button to upadate. what is the code of shift+f9, please?

 

[madhouse]

For the Shift+F9 code try "%^{F9}".