Results 1 to 2 of 2
  1. #1
    crhaines94 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    13

    Combo box uodating tabbed subform

    Hello!

    I could use some help getting a subform up update after updating a combo box. Right now I have it opening a new window when the search button is clicked, but I want my employees to view everything in 1 forum. I have attached a screenshot of the forum. I want basically all the forms to be tabs on a master form that is searchable by a combo box, and search button updates the subform (and goes to that record based on part number) so my employees dont have to open a new window to view each individual form. Each form has unique products that are grouped by category.

    Thanks!



    Chris



    Click image for larger version. 

Name:	Subform Help2.jpg 
Views:	5 
Size:	95.5 KB 
ID:	37052Click image for larger version. 

Name:	Subform Help.JPG 
Views:	5 
Size:	137.4 KB 
ID:	37053

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Options:

    1. intrinsic search/filter tools on ribbon or right click menu

    2. dynamic parameterized query as form RecordSource

    3. code sets form Filter and FilterOn properties or goes to record

    Review http://allenbrowne.com/ser-62.html
    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. Replies: 8
    Last Post: 08-26-2018, 11:00 AM
  2. tabbed control with combo boxes
    By vicsaccess in forum Forms
    Replies: 13
    Last Post: 12-15-2015, 11:43 AM
  3. Subform Refresh in a Tabbed Main Form
    By theosgood in forum Forms
    Replies: 5
    Last Post: 06-22-2012, 10:12 AM
  4. Goto a new record in tabbed subform
    By snoopy2003 in forum Programming
    Replies: 3
    Last Post: 03-05-2011, 04:24 PM
  5. Tabbed SubForm Issues
    By Exwarrior187 in forum Forms
    Replies: 5
    Last Post: 03-01-2011, 11:04 AM

Tags for this Thread

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