Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: Access Lookup question

    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?!

  2. #2
    Join Date
    Jun 2004
    Posts
    2

    Dont worry

    Dont worry ive done it now

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •