update query

M

Matt

I have a subform with fields that i want to update with an update query. Im
using the criteria
[Forms]![Form1]![DetailName]....however this doesnt work i suppose this is
due to it being a subform because that statement works when the form is open
by itself. How do i get this to work??

Thanks
 
O

Ofer

So mybe the syntax you are looking for is
Forms![MainFormName]![SubFormNameInTheMainForm].Form![DetailName]
 
M

Matt

Thank you

Douglas J. Steele said:
Yes, it's likely because it's a subform, rather than a form.

See http://www.mvps.org/access/forms/frm0031.htm at "The Access Web" for how
to refer to controls on subforms.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Matt said:
I have a subform with fields that i want to update with an update query. Im
using the criteria
[Forms]![Form1]![DetailName]....however this doesnt work i suppose this is
due to it being a subform because that statement works when the form is
open
by itself. How do i get this to work??

Thanks
Click to expand...
Click to expand...
 
Top