Ok I have 3 tbls Proj, Cust, C-empl. Cust consists of C-Id,C-name. C-empl consists of Emp-Id, C-Id, Firstname.
Proj consist of Proj-no, Description, C-Id, C-responsible.
I make a projectform where I put a textbox for all positions in proj, but for c-resp I want a combobox based on wich customer I choose in C-Id.
I made a Query selection from tbl C-empl with C-Id and firstname. C-Id has criteria [Forms]![Projectform][C-id].
When I run this I get askedfor [Forms]![Projectform][C-id] and if I enter 2 I get the right names for cust 2 in my combo.
I want it to change when I change customer in the C-id box.
This is the short version with the problem condensed the rest is working properly.
1 Why doesnt it pick up my textbox value ?
2 Do I need to make som sort of update when clicking the combo?
Patrik