Have form display results of query

Posted on 2002-07-29
Last Modified: 2010-05-18
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.


Question by:appelq
LVL 54

Accepted Solution

nico5038 earned 50 total points
ID: 7185901
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.


Author Comment

ID: 7193686
I knew it would be easy!

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now