I have a simple form with a single button on it that will run a query based on user input. Instead of that input returning the spreadsheet-type query results, how can I have the results display in text boxes on the same form?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
For instance, my form button runs the query:<o></o>
<o> </o>
SELECT UNIT_ID.UNIT_ID, UNIT_ID.MNEUMONIC, CORR_CODE.CORR_COND, CORR_CODE.MESSAGE<o></o>
FROM CORR_CODE INNER JOIN (UNIT_ID INNER JOIN CORR_DATE ON UNIT_ID.UNIT_ID = CORR_DATE.UNIT_ ID) ON CORR_CODE.CORR_COND = CORR_DATE.CORR_COND
WHERE (((UNIT_ID.UNIT_ID)=[Enter Unit ID]));<o></o>
<o> </o>
Unit_id.unit_id is a unique key with no duplicates so only one record will return. I would like the 4 ‘select’ fields to populate text boxes at the bottom of the same form that the input button is on. A bonus would be for the text boxes to be hidden until a result is returned.<o></o>
<o> </o>
Hope I explained that well enough. <o></o>
<o> </o>
For instance, my form button runs the query:<o></o>
<o> </o>
SELECT UNIT_ID.UNIT_ID, UNIT_ID.MNEUMONIC, CORR_CODE.CORR_COND, CORR_CODE.MESSAGE<o></o>
FROM CORR_CODE INNER JOIN (UNIT_ID INNER JOIN CORR_DATE ON UNIT_ID.UNIT_ID = CORR_DATE.UNIT_ ID) ON CORR_CODE.CORR_COND = CORR_DATE.CORR_COND
WHERE (((UNIT_ID.UNIT_ID)=[Enter Unit ID]));<o></o>
<o> </o>
Unit_id.unit_id is a unique key with no duplicates so only one record will return. I would like the 4 ‘select’ fields to populate text boxes at the bottom of the same form that the input button is on. A bonus would be for the text boxes to be hidden until a result is returned.<o></o>
<o> </o>
Hope I explained that well enough. <o></o>