Add Record and Display Previous Records - 2003

[oneilldm]

When I add a new record... Access scrolls all the previous records to the top and out of view.

Is there a way to control this so the user can see the previous records? (w/o having to manually scroll)

Thanks

 

[wazz]

hi there.
when you add a new record to what? do you have any code yet that we can look at? tnx.

 

[oneilldm]

Hi... thanks for the reply!

I have a simple "Tabular" form for a table that has 6 fields.

I added the "Add Record" command button with the wizard.

Here's the code for the button:

Private Sub NewRec_Click()
On Error GoTo Err_NewRec_Click
DoCmd.GoToRecord , , acNewRec
Exit_NewRec_Click:
Exit Sub
Err_NewRec_Click:
MsgBox Err.Description
Resume Exit_NewRec_Click

End Sub

 

[oneilldm]

One more thing.

When adding a new record, the new row always appears at the bottom of the form.

Is it possible to have it appear as the top row instead?

 

[oneilldm]

OK... There may be a cleaner way to do it, but this is what I came up with.

Private Sub NewRec_Click()
On Error GoTo Err_NewRec_Click
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acPrevious, 6
DoCmd.GoToRecord , , acNewRec
Me.Family_Number.SetFocus

Exit_NewRec_Click:
Exit Sub
Err_NewRec_Click:
MsgBox Err.Description
Resume Exit_NewRec_Click

End Sub

 

[oneilldm]

I still would like to figure out how to show the New Record at the top of the form.

I like to have the new stuff at the top with preceding records in descending order.