Link to home
Start Free TrialLog in
Avatar of appelq
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



ASKER CERTIFIED SOLUTION
Avatar of nico5038
nico5038
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of appelq
appelq

ASKER

I knew it would be easy!
thanks!