Using data from textbox to select field from table

[BillHesson]

I am trying to make a query that will take the value in a textbox on a form to determine the field to show from the queries underlying table. for example:
fields step, 1, 2, 3, 4, 5 and records a, b, c, d

step 1 2 3 4 5
a
b ......"x"
c
d
I have the query set up to select the specific record based on the step field, but I want to show the value from field that is determined by the entry from the form. Basically this is a pay scale that is based on step(a,b,c,d...) and class(1,2,3,4,5...) values both from the form and want to fill in the forms Pay textbox with the value of Class 2, step b("x") or what ever step and class is in the form. Any suggestions?

Thanks in advance!!

 

[Jon K]

I have attached a sample database.

You can open the form and select a Step and a Class from two combo boxes to display the Pay in a text box.

The code used is in the After Update event of the combo boxes. DLookup() is used in the code to look up the Pay from a table.
.

 

[BillHesson]

Thanks I will Check it out!!

 

[BillHesson]

So it was th "[" me.xxxx "[" that was messing me up I thought i tried all combos of the "'[]()"''" aint syntax a ***ch
Thanks!