update query

[Guest]

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

 

[Guest]

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

 

[Douglas J. Steele]

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.

 

[Guest]

Thank you

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!)

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