Many thanks dhookom and TheAceMan1 for replying.
Your pointers were spot on as I was incorrectly referencing the subform within the mainform. Works fine now. Many thanks to all for your help.
Brgds.
Thanks for the reply seaport.
Tried this and got the same response.
The 'Enter Parameter Value' dialog box shows part of the reference statement with the usual input, OK and Cancel options. If I manually enter the value into this the query will then work.
Tested the subform on it's own again...
Hi all.
I am trying to reference a subform control from a Query but am encountering a persistent error which suggests bad referencing on my part but I am at a loss to pinpoint.
Main form is frmCreateRFS
Subform is frmRFSHardwareSubForm
Controls EventType & DSTItemID
The intention is to select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.