I have a form that allows the user to transfer equipment from one storage site to another
Opening the form reveals the current site where the equipment is stored and the SiteID is passed to a Global variable G_SiteID
A combo box on the newly opened transfer form, “frmTransactor” uses that SiteID in an unbound text box "txtparam" to reveal the allowable sites that can accept accept the equipment. I always use a tect box on the form because I've had such bad luck maintaining stability of operation with variables in a QueryDef.
Select Case G_SiteID
Forms!frmTransactor!txtParam = 12 & " " & "Or" & " " & 99
Forms!frmTransactor!txtParam = 1 & " " & "Or" & " " & 99
Forms!frmTransactor!txtParam = 51
PARAMETERS txtParam Long;
SELECT tblSite.SiteID, tblSite.SiteName
However the combo box always come up blank on execution. What am I doing wrong?