Access Continuous Form Report

[Technics]

Hello guys. I have a continuous form that has enough info to have a scroll bar. When I open the form it jumps to the bottom of the list and new, for new record is in black. I have tried all the settings I can find on the subject, set tab order and set ID 1 as subject. ID 1 does appear in black but still the form jumps to the last or new record line and I have to scroll to the top of the page/records. One suggestion is to put new records at the top which may be fine but I have seen forms that start at the top with new record at the bottom. This form/report will be mainly editing existing records.

 

[DHookom]

Do you have any code in the Open event that moves to a new record? I just created a continuous form using the wizard and it opens to the first record requiring me to scroll down to get to the last or a new record.

 

[The_Doc_Man]

Default behavior for a form is to open the first record of the underlying recordset and not navigate from there. Therefore there has to be a cause to move (navigate) the records. This can be done via code in the Form_Open, Form_Load, or Form_Current event. Those three places are where I would look first.

However, your choice of nomenclature leads me to ask a question:

This form/report will be mainly editing existing records.

Which is it? Forms and reports behave very differently.

 

[Technics]

Do you have any code in the Open event that moves to a new record? I just created a continuous form using the wizard and it opens to the first record requiring me to scroll down to get to the last or a new record.

Nothing in the open event and I see nothing that relates to new record.

 

[Technics]

Default behavior for a form is to open the first record of the underlying recordset and not navigate from there. Therefore there has to be a cause to move (navigate) the records. This can be done via code in the Form_Open, Form_Load, or Form_Current event. Those three places are where I would look first.

However, your choice of nomenclature leads me to ask a question:


Which is it? Forms and reports behave very differently.

There is nothing in the events you mentioned and it is a continuous form that serves as a report for info entered daily.

 

[Technics]

Thanks everyone. Got it figured out. It was mentioned to me how was I opening the form... and there is the key. I had not thought about what was opening the form. It is a button on a completely different form that opens it and it had the line DoCmd.GoToRecord , , acNewRec that was doing it with new record at the bottom of the form. The form was doing exactly what it was suppose to do and when you use that cmd it puts the new record line at the top of the form and the word new located in the ID column is highlighted in black.