Results 1 to 4 of 4
  1. #1
    Viggen66 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    8

    Another problem with queries

    I have seem to have encounter another problem, with my database.

    I have built a combobox to search for managers, and based on those managers, records will be displayed on a subform.



    The main problem is that as I change from one manager to another, Access brakes the table by copying, the first record to another I have chosen, of course the combobox is a query.

    Is there a way to fix this?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,069
    It sounds like your "search" combo is bound to a table. It probably shouldn't be.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Viggen66 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    8
    Hi pbaldy

    Once again you have solved my problem, and I want to thank you for your assistance, you are truly worthy of an MVP designation, continue with your work.

    I have transformed the combobox to an unbound by eliminating in the Data proprieties the Control Source, and hence solved the problem.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,069
    Thank you, and you're welcome!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-08-2010, 06:12 PM
  2. Separate queries?
    By sid in forum Queries
    Replies: 0
    Last Post: 08-01-2009, 10:31 AM
  3. need help with queries
    By gromit95 in forum Queries
    Replies: 1
    Last Post: 02-06-2009, 06:50 AM
  4. Crosstab Queries
    By albst130 in forum Queries
    Replies: 0
    Last Post: 03-07-2007, 09:32 AM
  5. Queries to Form Problem
    By PnerraD in forum Queries
    Replies: 1
    Last Post: 06-10-2006, 09:13 AM

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