Number of Records Not Being Displayed in Split Form's Navigation Buttons

[JamesJoey]

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 one and
not any others is a mystery. I've checked and double checked my other forms to see if I can notice some difference
but found none. The record ID field is the first field in the tab order in all forms.
I found 2 ways to get the number of records to display.

1) When I use SELECT * FROM tblContacts ORDER BY Listing; in the onload of the form.
2) If I select the 2nd row in the datasheet.
I was using the select statement in the onload because I was filtering the records based on a Combo Box selection.
Access would save the filter by change the Record Source with a WHERE clause.
I have since abandoned the filtering using a combo box and have deleted the record type ID field form the table and
removed the Relationship.

This is the only form doing this. Creating a new form did no good.

I have half-a-mind to go back to continuous forms.

Any ideas?
James

 

[theDBguy]

How many records do you have in your table?

 

[JamesJoey]

214 records

 

[theDBguy]

214 records

Okay, that's not a lot and shouldn't stop Access from displaying the number of records in the Navigation Bar. Just in case you don't know, Access does not fetch all the records when you open a form. It only retrieves enough records to quickly have something to display to the user. Access will download the rest of the records as the users continues to work. This is its way of not making the user wait for a long time before they can start working.

 

[JamesJoey]

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.

 

[theDBguy]

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.

Hi. Sorry, can't answer that without being able to examine the problem form. Like I said, the number of records shouldn't prevent the record counter in the nav bar to display right away. So, there must be something else causing it.

 

[JamesJoey]

Here's the form.

 

[arnelgp]

i added code to the Load event of the form.

 

[JamesJoey]

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

 

[arnelgp]

it's a weird form, when you set the datasheet to the right, it will correctly display the
record number. that is because the Focus is on the single form and the navigation
is always at the left side.

 

[JamesJoey]

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

 

[theDBguy]

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

Hi. Can you repost a sample db with both the working and non-working forms? Just wanted to see if we can find any difference that could explain it.

 

[JamesJoey]

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.

 

[mike60smart]

Hi James

It displays OK for me

 

[JamesJoey]

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

 

[theDBguy]

Please open this one and let us know what you think.

 

[mike60smart]

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

That one works OK for me also

 

[mike60smart]

Please open this one and let us know what you think.

Hi Guy

That one also works for me but only 194 Records displayed

 

[Gasman]

Someone likes their steak well done?

Melt butter in skillet until hot
Mix flour, papriks and steak grill seasoning
and place on a plate
season steak with pepper then dredge through mixture
making sure not to coat meat too heavily
Cook 305 minutes on each side depending on size of meat

 

[theDBguy]

Hi Guy

That one also works for me but only 194 Records displayed

I'm surprised the first one worked for you.