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