I have attached a copy of what I am using.
When I open my form "frmworkordernumber", it works like I want. I click project number, client number pops in and it shows only work orders under that project in list. this is what i want it to do.
when I move it as a subform in the main form I keep getting and error. I think something is wrong with the naming of the form????? if you open the frm employeename (which is main form) I get an error.
If I go to the workorderid control in desgin view, and go to query builder, there is where i referenced the form. Because it is in the main form now do I need to change the name somehow? It works as in when form is stand alone but not when put in main form as subform......
can anyone help?
thanks