combo box values

[metokushika]

hi

i have 3 fields
that says
employee, regular rate and overtime rate.

i am using a combo box


where in, if the user chooses
a name from the employee,
automatically the two text boxes
in my form should show
the value of regular rate and
overtime rate separately.

it's like i want to retrieve
the whole record according
to each employee.

is there any way i can do
that?

[alansidman]

Look at this link from Paul. It is the best explanation I have run across on how to make this happen.

http://www.baldyweb.com/Autofill.htm

Alan

[metokushika]

thank you!
thank you!
thank you!