Results 1 to 2 of 2
  1. #1
    loneman is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    3

    datasheet won't populate data

    Hi, I am new to Access. I created a split datasheet form and
    added the following code to form load event.

    Private Sub Form_Load()
    Dim sql As String


    sql = "Select * from employees"
    Me.RecordSource = sql
    End Sub

    When I open the form all I see is the bottom record bar 1 of 31 records.
    I don’t see anything in the datasheet. How can I populate the data?
    I like to do this in VBA …thank you for your comments!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    put in a subform bound to the query. just because you opened a form and ran the sql, doesnt mean you gave it anything to output to. Subform would be your best bet here.

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

Similar Threads

  1. Replies: 0
    Last Post: 05-12-2010, 10:08 PM
  2. Replies: 6
    Last Post: 04-14-2010, 11:03 AM
  3. Populate one field based upon another fields data
    By BigBrownBear in forum Queries
    Replies: 1
    Last Post: 03-23-2010, 04:27 PM
  4. populate table w/ external data
    By tlittell in forum Programming
    Replies: 2
    Last Post: 02-20-2010, 08:29 AM
  5. form data will not populate in table
    By bobsakamato in forum Access
    Replies: 1
    Last Post: 09-06-2009, 07:25 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