Update form after note is made

[Guest]

Hi all,
I have an order summary form that has a button to add notes. When clicking
on the button, a new form appears and allows the user to enter notes. What I
was wondering is if there was any way for when the notes form is closed, to
have the note then appear in a notes field on the order summary form? I have
tried using the refresh, requery methods, but am not having much luck.
Any help would be greatly appreciated! Thanks!
-gary

 

[Guest]

Or you can do it another way if you like by putting inserting this code:

DoCmd.RunCommand acCmdZoomBox

on the OnEnter Event property of your notes textbox on the orders summary so
when u click the notes textbox, a zoom box is generated for you to enter your
notes and once you click ok, u can see your notes on the orders summary
instead for having a button.
Hope this gives you an alternative.

 

[Guest]

Thanks! That is a cool feature that I did not know about! However, for my
situation, it will not work
When I click on the button to add a note, it opens a form that also gives
the option to print the note that was just entered and I would like to keep
this feature. I know I could rework everything to be on the main form, but
is there anything that could be done to have the newly entered note appear on
the main form when the note form is closed?
Thanks!
-gary

 

[Guest]

I have just solved this problem in my application. I have a main form with a
subform. There is a button on the subform to add a new record which opens a
modal form.

In the Form_Close event of the modal (pop-up) form I have inserted the code:

Forms("formname").Requery

Where the 'formname' is the name of the mainform, not the subform.

I hope that helps.

-Paul.

 

[Guest]

Awesome! That worked great! Thanks for getting that information to me!
-gary