Referring to Sub-Form Control in a QueryThis is a discussion on Referring to Sub-Form Control in a Query within the ADO DAO RDO RDS forums in Framework and Interface Programming category; How do you refer to a sub-form control (on an open form) in a query? The code below is incorrect and opens the "Enter Parameter value" window. Forms!MainForm!SubForm.Forms!ControlName... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
11-09-2008, 09:48 AM
| |||
| |||
 Referring to Sub-Form Control in a Query How do you refer to a sub-form control (on an open form) in a query? The code below is incorrect and opens the "Enter Parameter value" window. Forms!MainForm!SubForm.Forms!ControlName  |
|
#2
11-09-2008, 09:59 AM
| |||
| |||
| Re: Referring to Sub-Form Control in a Query "JimP" <j_pockmire@comcast.net> wrote in message news:6c2dnUhi_NTWZYvUnZ2dnUVZ_gadnZ2d@giganews.com ... > How do you refer to a sub-form control (on an open form) in a query? The > code below is incorrect and opens the "Enter Parameter value" window. > > Forms!MainForm!SubForm.Forms!ControlName You almost had it: Forms!MainForm!SubForm.Form!ControlName SubForm.Form means 'the form hosted by the subform control' |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 10:05 PM.
