Microsoft Access cannot find the referenced form 'frmTagPrintEquip'

bama4954

New Member
Joined
Oct 31, 2018
Messages
35
I am running SQL statement but get the title error. The form is a lookup combo box that is closed until a cmd button opens it.

strSQL = "SELECT tblTag.TagNumber, tblTag.TagID, tblEquipment.Equipment, tblEquipment.EquipID, tblTurnaround.TurnaroundID " & vbCrLf & _
"FROM tblTurnaround INNER JOIN (tblEquipment INNER JOIN tblTag ON tblEquipment.EquipID = tblTag.EquipID) ON tblTurnaround.TurnaroundID = tblTag.TurnaroundID " & vbCrLf & _
"WHERE (((tblEquipment.Equipment)=" & Forms("frmTagPrintEquip").Controls!cboEquipNumber.Value & ")) ORDER BY ([SOW_Number])ASC "
 
Last edited:

JonXL

Board Regular
Joined
Feb 5, 2018
Messages
222
Is it closed when that SQL runs? Because it needs to be open and not in Design view.
 

bama4954

New Member
Joined
Oct 31, 2018
Messages
35
I got it figured out. I needed to open the form before the SQL runs. Duh... Thanks a lot for you help!
 

Forum statistics

Threads
1,077,959
Messages
5,337,413
Members
399,144
Latest member
Lauren Ward

Some videos you may like

This Week's Hot Topics

Top