como box update

[john]

im trying to refrence a control on my sybform
my mainform is orders and my subfrom is order details

im useing the after update event

me!orders!order_details!productID.requery
but its not working wats the corredt way for refrencing a control on a
subform?
thanks in advance

 

[Allen Browne]

Try:
Me!Orders![Order Details].Form!ProductID.Requery

For an explanation of the ".Form" bit see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

 

[john]

thanks it didnt work but then i tried this
Forms![Orders]![Child12]![ProductID].Requery
i didnt realise that the subform was refered to child12 in my main form!
douh!!

Try:
Me!Orders![Order Details].Form!ProductID.Requery

For an explanation of the ".Form" bit see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

im trying to refrence a control on my sybform
my mainform is orders and my subfrom is order details

im useing the after update event

me!orders!order_details!productID.requery
but its not working wats the corredt way for refrencing a control on a
subform?
thanks in advance