Still no luck,
Maybe more info will help.
My form is 'Monthly Input Invoice and MTR'
The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'
The further down on the form, I want the user to click on a combo box
for 'project code' choices. There are hundreds of project codes, but
I only want the project codes selected to be those that have the same
contract number that the client has in the 'ClientContract' text box.
The project codes are stored in a table called 'Unitcost by Contract'.
I hope this helps, I am going nuts trying to figure this out.
Thanks in advance!
Sue
John W. Vinson said:
On Fri, 8 Jan 2010 17:00:01 -0800, Sue R
In the Row Source for the combo box I have entered:
WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))
It still doesn't work. Help, I am pulling my hair out and my head
is getting sore!
YOu may also need to Requery this combo in the AfterUpdate event of
the ClientContract control.