June7Would only remove Private if want to call from another procedure. Guessing you plan to do that because not it seeing it now.
Need apostrophe delimiters because CustCode, CustID, EndCustomer are all text fields.
Me.UncoatedGSMID.RowSource = "SELECT Stdrateid, Uncoatedrate FROM tblCustFabricConvRates WHERE CustID='" & Me.EndCustomer & "' AND " & Me.UncoatedGSM & " BETWEEN GSMMin AND GSMMax;"
This trail is old as I could not, for some reason, pursue this development and am now in the process to finalise this.
The DB is enclosed. I am facing one issue for which I need help. I need to develop a form for the table tblCustFabricConvRates. The queries are in place and working.
As you would see from the table structure, for each customer code there are 17 sets of rows of data and in these 17 rows, 2 sets of information - the fields GSMmin and GSMMax are repeated. From the data entry perspective, the form should be such that once a new customer is entered, the 17 rows of data are created in the form with pre-filled data of GSMMin and GSMMax and the balance 2 fields - UncoatedRate and CoatingRate blank, which the user would fill in.
In the conventional way of creating the forms, this is not possible!