forms,queries,comboBoxes

[accessnewbie]

I have a tabbed form that has a simple comboBox on the first "tab". This comboBox has a macro on it that will take the user to "tab 2" upon making the selection in the combo box. I need to "grab" the users selection and use it in a query on "tab 2" How would I do this? I can write it in SQL but it doesnt work. It looks something like this:


SELECT medical.amount1,employee.Name,
FROM medical, employee
WHERE employee.Name = Forms.clienttabs.Combo26;


I keep getting the '#Name?' error. Any ideas on debugging or possible problems/solutions are greatly appreciated.

Thanks

 

[Stopher007]

I think the word Name is reserved in Access for other uses os I think this may be where your problem lies. And possibly you need to tell it that your information is in character format ie & chr(32)