Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. #31
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by June7 View Post
    So your answers are:

    There is an Access query object with that SQL statement.

    You want code to replace the sql of the query object to include a parameter from combobox.


    My response:



    Do not use VBA.

    Use a reference to combobox in the Access query object.

    If the dynamic parameter in query object does not work then there is something else seriously wonky about the query and no amount of VBA will help it anyway.
    blinks... ok

  2. #32
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Gasp*

    It works.

    I just referenced it to the form. I was hoping not to (in order to use the qry for other purposes) but if that is the only way then that is ok by me.

    Thanks June

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-03-2012, 04:20 PM
  2. Replies: 7
    Last Post: 07-14-2012, 01:02 AM
  3. how to refer to if attachment count is zero vba
    By aspen in forum Programming
    Replies: 3
    Last Post: 05-03-2012, 05:56 AM
  4. Refer to ONLY THE MONTH??
    By taimysho0 in forum Programming
    Replies: 18
    Last Post: 01-27-2012, 01:12 PM
  5. Replies: 10
    Last Post: 08-08-2011, 01:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums