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-com
ffice
ffice" /><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


For instance, my form button runs the query:<o


<o


SELECT UNIT_ID.UNIT_ID, UNIT_ID.MNEUMONIC, CORR_CODE.CORR_COND, CORR_CODE.MESSAGE<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


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


Hope I explained that well enough. <o

