Update Subform

[DontKnow]

Hi Guys,

is there a function that I can utilise to update a list of "pre-loaded"
questions in a subform. What happens is when you double click in the
subform, A form is activated whereby you are able to update existing entries
or add extra entries. What I require is a function that is capable of
updating the subform for an existing entry and/or add a new record?

how would i dop that??

 

[bhicks11 via AccessMonster.com]

There's a couple of ways to do this. You can put a little code in the on
current event of the form that sets the value of each control or you can run
a macro that does the same. You can also set the default value of each
control in the control's properties.

Bonnie
http://www.dataplus-svc.com

 

[DontKnow]

The current event of the form or the subform? What would this code be? (I am
thinking a me.refresh)?

Thanks for your help Accessmonster!!

Cheers!!

 

[bhicks11 via AccessMonster.com]

Please clarify your process - I'm a bit confused by which is the form and
which is the subform. If you are on a form (or subform) and open a pop-up
form and then fill in some controls that you then want to use to update the
subform you left you can leave the pop-up form open but set it to not visible.
When you return to the original subform, you could do something like:

me.controlonoriginalsubform = forms!popupform.control

Or maybe I don't understand what you are doing?

Bonnie
http://www.dataplus-svc.com

The current event of the form or the subform? What would this code be? (I am
thinking a me.refresh)?

Thanks for your help Accessmonster!!

Cheers!!

There's a couple of ways to do this. You can put a little code in the on
current event of the form that sets the value of each control or you can run

[quoted text clipped - 13 lines]