Results 1 to 3 of 3
  1. #1
    accesslover is offline Novice
    Windows 11 Access 2021
    Join Date
    Jan 2023
    Posts
    9

    view all records in vba form


    hello
    i attached a access db
    I would like to view all records in one form using vba
    test4.accdb

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    no need to use vba.
    put a combo box in the header , with queries in it.
    user picks a query,
    that data then shows:

    Code:
    sub cboBox_afterupdate()
      me.recordsource = cboBox
    end sub
    ok, that last line is VBA.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    First you need to set the form recordsource property to the table name.

    Click image for larger version. 

Name:	rs.png 
Views:	18 
Size:	23.1 KB 
ID:	49642

    Then bind the form textbox controls to the table fields. Example shows one textbox.

    Click image for larger version. 

Name:	bind.png 
Views:	18 
Size:	28.6 KB 
ID:	49643

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

Similar Threads

  1. Replies: 2
    Last Post: 01-14-2015, 12:00 PM
  2. View only specific records in form view
    By drnld in forum Access
    Replies: 5
    Last Post: 07-22-2014, 12:21 PM
  3. Replies: 8
    Last Post: 04-29-2013, 11:23 AM
  4. Cannot view all records in form view
    By thar2hag in forum Forms
    Replies: 1
    Last Post: 11-01-2012, 08:43 AM
  5. Show only some records in Form View
    By Douglasrac in forum Forms
    Replies: 3
    Last Post: 05-15-2011, 11:01 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