appelq
asked on
Have form display results of query
Ok, This has got to be easy, but my brain is not on all firing on all cylinders today.
I have a form with one field : EmployeeID and a
[Run] button that runs a macro.
The Macro runs a query to use ODBC to get an Employee record from another database, and import it into a local temp table. The macro also does a couple other queries that message the data, and fills in values in other columns of the temp table, like Pay Rate whic is looked up on a table based on Seniority and other factors.
At this point I have one record in the temp table, and I want to display about 5 fields from it on the form.
So I have 5 text box fields on the form, but I need to efficiently display the fields I want from the temp table.
Thanks,
Chuck
I have a form with one field : EmployeeID and a
[Run] button that runs a macro.
The Macro runs a query to use ODBC to get an Employee record from another database, and import it into a local temp table. The macro also does a couple other queries that message the data, and fills in values in other columns of the temp table, like Pay Rate whic is looked up on a table based on Seniority and other factors.
At this point I have one record in the temp table, and I want to display about 5 fields from it on the form.
So I have 5 text box fields on the form, but I need to efficiently display the fields I want from the temp table.
Thanks,
Chuck
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks!