como box update

  • Thread starter Thread starter john
  • Start date Start date
J

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

Allen Browne said:
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.

john said:
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
 
Back
Top