Help Please- Linking a Table to Text Boxes

[graviz]

Here is what I have:

A Form called "Main"
A Combo Box called "cboOffice"
On the form 4 text boxes:
"txtFSS1"
"txtFSS2"
"txtFSS3"
"txtFSS4"

I also have a table called "Point_Lookup"
It has 3 fields in it:
Office_Name: Which has the same values as the combo box on the form
Tech_Level: Which I would like to match up with each of the text boxes. (i.e. Tech level 1 = FSS1)
Points: Each tech level has a certain number of points.

So basically in the table each office has 4 rows (1 for each tech level/points)



Example:
Office_Name Tech_Level Points
Office A FSS1 50
Office A FSS2 60
Office A FSS3 70
Office A FSS4 80

So what I'm trying to do if when someone selects an office from the combo box I would like all of the text boxes to fill out with their appropriate points levels based on the table.

[graviz]

Tried the DLookup and no luck with it.

[ConneXionLost]

From your description, is seems you are trying to get the form to display four records from the table simultaneously. This is not a natural way to get a table and form to interact.

Two solutions:

Either change the structure of "Point_Lookup" to match the form, such:

"Tech_Level"
"txtFSS1"
"txtFSS2"
"txtFSS3"
"txtFSS4"

Or build a parent table for "Office_Name" and add a subform in "Main" to record "Tech_Level".

Cheers,