Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 06-04-2004, 01:11 PM   #1
Registered User
Join Date: Apr 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
wjmorgan is on a distinguished road
Exclamation 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.
wjmorgan is offline   Reply With Quote
Old 06-04-2004, 02:19 PM   #2
Registered Perpetrator
Join Date: Dec 2000
Location: Golden, CO, USA
Posts: 263
Thanks: 0
Thanked 2 Times in 1 Post
DALeffler is on a distinguished road
Did you try:

Forms("frmUserPipeline")("subfrm_Pipeline").Form(" DateRouted") = Calendar
(Learns from mistakes; have scars to prove it...)
DALeffler is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 03:37 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World