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.Value = 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?
Forms!frmUserPipeline!subfrm_Pipeline!DateRouted.Value = 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: