Search results

I noticed that the file you have in Post 16 works fine. But, there's 194 records as opposed to 201. Seems the pone that works had 20 records deleted stead of 13. So I went into the datasheet and deleted 7 more records (around the 300 ID or so, I forget) and the split displayed the number of...

I didn't miss it I misunderstood it. I deleted the IDs from 323 to 339 and it still not displaying the number of records. It did delete 13 records leaving a total of 201.

There's 214 records in the table. I open the datasheet and sort lowest to highest on the ID field. I select ID 323 and the navigation buttons report record 44 of 214.

Ok, but I'll be deleting 170 records of 214 records. That leaves me 44 records.

I'm assuming I can add the deleted records back in?

The ContactID number 323 shows up in the original table but not in the files you sent me. Not sure if it matters, there is a duplicate Listing at 323. The duplicate is 325.

I don't quite understand. I don't see a record ID 323. Am I missing something?

Yes this helped much. As far as the table is concerned, I unlinked it and relinked, I imported it directly into my db.

What did you do to get this to work? For days I opened this form an another form that worked in design view and went back and forth to compare properties.

Yes it worked fine. Also if I set the RecordSource in the onload in works.

I deleted several records form that table. I don't know. If I open the form frmContactsNotWorking it does not display the number of records. Gasman your making me hungry!

Sorry I attached the wrong one.. That's the form arnelgp placed the GoToRecord in the OnLoad. Try this one.

Notes tables works and Contacts doesn't. In the Notes db I have some recipes. I wouldn't even try any of them. I put them in.

But I still must ask why are all my other forms displaying the record number correctly? They, too have the datasheet on the left.

Didn't think of that. But regardless, One must still add something to the onload. This is fine, though. I was just trying to figure out why this is happening with this form and not any of my other forms. Of course I could just set the Navigation Buttons property to no. Thanks, James

Here's the form.

Why is this the only form doing this?? Why does it retrieve all when I select the second row in the datasheet?? One more thing I failed to mention. When I set the Split Form Orientation to top, bottom or right, the number of records displays properly.

214 records

I have a split form with the datasheet on the left. This seems to have been an ongoing issue with the Navigation Buttons at the bottom of the form not displaying the number of records. This is occurring now only on one form but in the past it was happening om all my split forms. Why only this...

I wouldn't care for that, :(