subform requery

G

Guest

I have a form for entering information about jobs. On this
form is a subform for entering radioactive dose amount
recieved while performing the related job and another
subform that displays the current total dose for all jobs.
The total is meant to be a running sum.

I am having trouble making the total form update to the
new data when a dose number is entered or changed. I tried
putting a requery in the afterupdate of the dose entry
textbox but it won't recognize the subform.
 
M

Marshall Barton

I have a form for entering information about jobs. On this
form is a subform for entering radioactive dose amount
recieved while performing the related job and another
subform that displays the current total dose for all jobs.
The total is meant to be a running sum.

I am having trouble making the total form update to the
new data when a dose number is entered or changed. I tried
putting a requery in the afterupdate of the dose entry
textbox but it won't recognize the subform.


You probably missed something in the reference's syntax.
From on subform to another, it would be:

Me.Parent.subform2.Form.Requery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top