Search results for query: *

=RecordsetClone.Recordcount WORKED!!!! Thanks!!!!

Not sure what you mean... just use defaults when creating form. Tried with a test form and no good. It looks like this in the form's property sheet: =[recordset].[RecordCount] ... but comes up #Name? in the field. A.

Thhe form has this in the Filter property: ((((Main.[Account Type])<>"NON" And (Main.[Account Type])<>"TBF"))) Recordset Type is Dynaset. So what exactly should I put in the text box on the form...? Thanks, ASF

It puts #Name? in the field.

=Recordset.RecordCount didn't work. I tried tablename.recordcount and formname.recordcount, and everything else I could think of... to no avail. ...but thanks for the suggestion.... A.

Now how do I show ALL the records? Can't find anything like [TotalRecords]....

Yes, of course. I should have known. Mea culpa. THANKS!

Anyone know an easy way to show the current record number on a record-filtered form -- without showing the navigation arrows? (I don't use control numbers.) Example: There are 1000 records in the "Main" table. The form is filtered and shows only those west of the Mississippi river -- 400...

Does it require you to put this? Call subNextRecord() ------------------------ Yes, that worked, and I've figured out my other problems. Thanks!

You mean this? Private Sub Command399_Click() subNextRecord End Sub It doesn't work. I get an error: "Expected variable or procedure, not module." Thanks!

How do I call a module from a button on a form? I go to the OnClick poperty, then open "Code Builder," and I see: ----------------------------------- Private Sub Command399_Click() End Sub ------------------------------------- So what the heck goes in the sub to actually run my module (which...