Can noone do this? Pass a value to a subform???
I need to pass a value to a subform but can't figure out the correct syntax. I am using office 2002 (db is 2000 format) and everytime I try to pass a value to a subform I get "Can't find the field" and the field it's looking for is the name of my subform? Here is the syntax I have (that doesn't work)
Forms!frmUserPipeline!subfrm_Pipeline!DateRouted.V alue = Calendar.Value
I tried adding .form to the end of the subform name and that didn't work, I tried to surround everything in  and that didn't work, i'm at my wits end with this thing. It's something so friggin simple yet it's driving me nuts. I can't do requery correctly either, it takes the subform name and thinks its the field name. I even use the property caption of the subform and that didn't work either. Is this function not available in the later versions of Access?
Last edited by wjmorgan; 06-04-2004 at 01:13 PM.