Quote:
Originally Posted by robtyketto
Greetings,
I have a form where a combo box is used to select a name and Id.
Theses values are passed into a subform.
However the query now returns 0 results.
So I edited the query and hard coded the same value as can be seen in the table and rows retrieved.
Now in the form I get strange behaviour where 1 out of 5 times I get results results. Are sub forms buggy when reference form fields as follows:-
[Forms]![frmModuleResults]![txtModuleId]
I capture the values in VBA of the form control and they are exaclty as they should be and if hardcodied into the results, rows are retreived.
Really frustrated.
Any tips or advice?
Cheers
Rob
Rob,
I am not certain whether you used the master/child links to auto connect the main form and the child form. I am also not clear whether you are executing code on the main form to drive the subform. If you are, then you would reference the subform like one of these options:
Reference a control on the subform:
Forms!YourMainForm!YourSubformControl.Form!YourCon trol
Me!YourSubformControl.Form!YourControl
Reference a method to be executed on the subform
Me!YourSubformControl.Form.Requery
Hope this helps. If not provide more details.
