Search results

  1. M

    Changing the criteria of a query depending on a form

    Thank u Dave, I think I need to learn more about tempvar Thank u for your response. Regards,
  2. M

    Changing the criteria of a query depending on a form

    Thanks @Minty for your review and your kind response, I will try this so.
  3. M

    Changing the criteria of a query depending on a form

    I'd like to thank you all for this effective forum; I was able to find the solution after going thru similar inquiries, also I found the discussion between @whitty15 and @EMP very helpful to me. Therefore, I'd like to share the answer with you all to share the knowledge. The query expression...
  4. M

    Changing the criteria of a query depending on a form

    I have a query that is using a form named "DateRange2" to change the criteria of one field "Dept1" in order to filter this query. Then the I designed a report that can be opened by using a command button 'cmdOpenReport' with form VBA code: Option Compare DatabasePrivateSub Form_Open(Cancel...
Top Bottom