Go Premium for a chance to win a PS4. Enter to Win

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 720
  • Last Modified:

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.


1 Solution
Just create a subform with the five fields.
Link this (manually) with the EmployeeID field in the subforms properties.

Now issue a refresh as the last macro command and you'll see that access will show the added employee.

appelqAuthor Commented:
I knew it would be easy!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now