Search results

Sorry its taken awhile to reply but i've just tried your suggestion and unfortunately it didn't work until i did the following: strFilter = "[tblProjects].[intprojectyear] = " & strYear & " And [tblProjects].[intprojectjobno] = " & strJobno Now it works a treat. Thank you so much for pointing...

Hi I've tried to find an answer to this but having no luck. I have a form that has two combo boxes the first box looks up the year from the project table and the second box the project number. I want to open the project details that correspondes to these two input values within the combo boxes...