Results 1 to 2 of 2
  1. #1
    quicova is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    53

    Multiple Item Form search and combobox problem

    Hello,

    I'm very new to access, I started looking at it this week only

    I created a form with the style "Multiple Items", w
    hich gets its data from a query.

    On the form header I created a couple of comboboxes and a text box to filter the query and search for items.
    I also added some bottoms to open popup forms to add items.

    Everything is working, when I change the values in the comboboxes and type a search on the text box the query filters as expected.
    Also when I add a new items with the popup form it adds the item to the main table and to the query.



    However my problem is it doesn't update in the Form when I change the combobox or add items or type in the search. I have to manually open the query has a query window to see the results of the comboboxes. The data in the multiple item form is always the same.

    Is there a bottom I can create to update the form, or for each combobox set an event to update the form to match the new query results?

    Hope someone can help me out
    Thanks so much
    Francisco
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    You using a parameterized query as the form RecordSource? Need to requery the form: Me.Requery
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Multiple item form from query to table
    By Jkwb in forum Access
    Replies: 13
    Last Post: 01-15-2013, 10:35 AM
  2. Replies: 7
    Last Post: 08-08-2012, 03:28 PM
  3. Sum data from multiple item form
    By swavemeisterg in forum Forms
    Replies: 2
    Last Post: 06-14-2012, 09:05 AM
  4. Selecting a combobox item with VBA
    By tylerg11 in forum Forms
    Replies: 6
    Last Post: 04-19-2012, 12:30 PM
  5. Replies: 2
    Last Post: 12-21-2010, 12:03 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