Displaying data based on ComboBox selection

[froggiebeckie]

I'm building a new db for tracking tests/results, using Access 2007.

On this issue, I'm working with 2 tables, Sample and Equipment.

On a form to enter sample info, I have a combo box to select a piece of equipment.

When the equipment is selected, I need to have a sub-form populate with several fields of data from the equipment table, based on the equipment selected.

I'm not trying to save the equipment data again, I just need to display it, based on the equipment the user selects. This is just a kind of second check to remind the user what the equipment he's selected will do.

I know I've done this before, but I just can't remember how I did it.

Any suggestions to get my brain a jump start?

Thanks, in advance.

 

[jdraw]

What is a sample?

 

[froggiebeckie]

The tables I mentioned are just 2 of many.

For example:

Product Number (Primary Table--A unique product that we will be testing. Nothing happens without a record in this table)
Sample (Secondary Table--we will take multiple pieces of a product and run different tests on it.)
Equipment (Individual Equipment, designed to do specific things to the Sample(s), with different attributes.)
Test Results (Outcomes of tests to the Sample.)

Etc.

In this db, (after the Product has been entered) when I select a Product to test, I need to create a Sample, with test requirements and I have a form to do this.
On this form, when I select the Equipment I want to be used for this test, I'd like to display the attributes of that equipment, so the user can be sure they've selected the correct Equipment.

Hope that makes it clearer, without cluttering up with unneeded details.

 

[Keith Tedbury]

The sub form is it a Continuous or single form. You could have a query as the record set for the sub form and filter the query using the combo box to show the relevant records.

 

[Mihail]

What is a sample?

So: What is a sample ?
What fields contain this table ?
How is related with table Equipments ?
Is this table related with table Equipments?

The simple answer is: use the value of combo in order to filter the subform.

 

[froggiebeckie]

Problem solved--issue was the Master/Child tie. As usual, it's the simple things that hang me up.
Thanks anyway.