You are using ac2010, right?
You are using ac2010, right?
If your form has no RecordSource, it will not have a RecordsetClone.
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. ???
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
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.
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
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.