Can noone do this? Pass a value to a subform??? (1 Viewer)

wjmorgan

New member
Local time
Yesterday, 20:18
Joined
Apr 23, 2004
Messages
6
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?
 
Last edited:

DALeffler

Registered Perpetrator
Local time
Yesterday, 18:18
Joined
Dec 5, 2000
Messages
263
Did you try:

Forms("frmUserPipeline")("subfrm_Pipeline").Form("DateRouted") = Calendar
 

Users who are viewing this thread

Top Bottom