many records see more records - Open Form to New Record in Microsoft Access


	Back to Open New Record Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

many records see more records

Avigder Webeber

3 years ago

When there are many records, more than the form can contain at once, the form opens only with the new line. If I want to see more records and only stand on the new row by opening the form, I need to press page up, Then I see the new line at the bottom of the form, and above there are as many records as the form can contain.

	Scott Axton @Reply 3 years ago
You are probably going to have to provide some screen shots. I'm assuming the form you are speaking of is a continuous form. How are you opening it?

	Avigder Webeber OP @Reply 3 years ago
Thank you The first picture I'm going to upload is when I open the form on "DoCmd.GoToRecord, , acNewRec" The second picture will be after I scroll the form up and down

	Avigder Webeber OP @Reply 3 years ago

	Avigder Webeber OP @Reply 3 years ago

	Richard Rost @Reply 3 years ago
Yeah, that's the behavior if you're going to go to a new record. To avoid that, issue three commands: Go to new record Go up X records (however many you want to see on a screen) Go to new record Personally, I like to use the New Record on Top method.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Open New Record.

Next Unseen

New Feature: Comment Live View