Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are using ac2010, right?

  2. #17
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If your form has no RecordSource, it will not have a RecordsetClone.

  3. #18
    d9pierce1 is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Hi RG,
    Yes, am using 2010 and it is an unbound form. This code from what I have read should allow me to use unbound forms and such and this should show the recordcount. ???

  4. #19
    d9pierce1 is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    OK RG,
    I changed form to bound to the table and it works! The only thing is I didnt want to have any bound forms in creating this. Is there a way to do this without binding the form?
    Thanks
    Dave

  5. #20
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can have a RecordSource to the form and still have all of the controls unbound as you have. Setting the RecordSource of your form to the table (or more appropriately a query of that table) will keep you from getting that error. Just so you know, I have only found one situation where an unbound form made any sense.

  6. #21
    d9pierce1 is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    Smile Solved

    Thanks RG,
    I will work with this a while and I do really appriciate your help. This may be the way to go. I am going to start buttons now, that should be interesting!
    Thanks again
    Dave

  7. #22
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The only reason for setting a RecordSource for the form is so your CurrentEvent code works. You can get the RecordCount in the Load event if you want and not need the CurrentEvent code. BTW, if there is no RecordSource for the form then you will not be able to use the CurrentEvent. Most of the power of Access is when using a bound form.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Navigation Bar
    By hitesh_asrani_j in forum Forms
    Replies: 5
    Last Post: 10-24-2011, 10:19 AM
  2. Navigation form
    By Wayne311 in forum Programming
    Replies: 10
    Last Post: 02-10-2011, 01:06 PM
  3. Help with navigation
    By phelpsville in forum Access
    Replies: 0
    Last Post: 04-16-2010, 07:33 PM
  4. Navigation Pane Issue
    By mimi in forum Import/Export Data
    Replies: 0
    Last Post: 02-23-2010, 01:29 PM
  5. Replies: 1
    Last Post: 11-13-2009, 03: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