I am having a bit of trouble with the lookup expression in access.
I have created a summary form which has a check box for each report a business unit has to complete. There is also a form that enables the users to fill out the reports and tick a check box to indicate it is complete. I am trying to get the check box's on my summary form to automatically check/tick themselves by checking if a report is complete when the user selects their business unit from a combo box on the summary form. I can find the complete flag in the table by using the DLOOKUP,,, where the Business unit in the table is equal to the combo box on the summary form but i want the criteria to be more specific.
I want to use the subject of the report too but the only reference i have to that in the summary form is the label's for the check box's and when i try to use them in the where expression it doesnt like it.
Is this the problem? cant you use the labels as criteria? is there a better way to do what im trying to do? Any help would be greatly appreciated.
I hope my dilema is clear and that i havent confused any would be helpers?!