I have attached the part of my database I am having trouble with. I am trying to get the combo boxes to work as follows.
when project number is clicked the client number is automatically put in client number field. and then the work order number that goes with project number picked is listed in work order number combo box.
It works now from project# to workorder# but doesn't put in the client number?
I have tried them separatley and they eash work. I am trying to do it all in one click. Maybe my code is wrong or i need more code?
If anyone can help it would be greatly appreciated.