Form with the new record on top?

[Timoty]

I don't want to waste time trying to accomplish the impossible so I will ask the experts (the end users). I have a form based on two linked queries. A main form and a subform. The main form is based on a list of clients with tombstone data and the subform is a list of couses taken. Works fine.

Problem is this....after time the number of course extends past the forms limitss. Each time the user wants to enter a new record they have to select the user, then scroll down to the bottom of the list in the subform. A royal pain in the behind.

Is there a way to force the subform to display the records in reverse so that the blank (or new) record is at the top, instead of the bottom?

Thanks again......the family here never ceases to amaze me!

 

[FoFa]

Why not just put an "Add New" button on there and let them click that to take them to the new record row?

 

[Timoty]

Thanks...that was a work around...BUT

But just out of pure curiosity now....can it be done?

 

[Temmu]

turn wizard on on toolbar (is on by default)
select command button, drop on form
select record navigation, goto new record

voila

or, if you prefer macros -

turn off wizard on toolbar (wand with stars)
select command button, drop on form
open properties dialog
select event tab
select on click
click the elipsis button [...]
choose macro
name the macro something like btnaddrecord
choose gotorecord
select form, nameofform, new
no need for offset.

voila!

 

[ansentry]

Make a command button put it on the Main Form call it cmdGoToNewRecordSF, put this code behind it and that will do the trick. Now make sure that you use the control name of your subform.

Private Sub cmdGoToNewRecordSF_Click()

Me.[COLOR=Blue][B]NameofYourSubForm[/B][/COLOR].SetFocus

DoCmd.GoToRecord , , acNewRec

end sub

 

[Rich]

But just out of pure curiosity now....can it be done?

No, not without unbound forms and reams of code

 

[Timoty]

Thanks....and if anyone is feeling academic !

Thanks to all.....the add new record button is doing the trick. If anyone has the code to do what rich has suggested...or if anyone has a sample DB with such code that I could work from....that would be great. I have to believe that I am not the first person who could use a database that has the newest records at the top. I belive microsoft needs to add a patch.