Have a Blank Entry Form @ The Top in a Coninuous Form in Microsoft Access

I have a continuous form, that I am using as a subform and it is annoying to have to scroll to the bottom of all the entries to enter a new record.

Is there a way to force the "blank" entry record to the top?
rogerdjrAsked:
Who is Participating?
 
pteranodon72Commented:
In Access, the place to enter new records is always at the bottom row. You can change the form's to Data Entry property to true to hide previously entered data, but that's as close as you'll get without reinventing the wheel. You can add a "New Record" button in the form's header or click the >* button in the navigation buttons to avoid scrolling.

pT72
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Is there a way to force the "blank" entry record to the top?"
No, sorry.  One trick is to use the Form Header and add the same set of controls (text/combo boxes, etc) and use the for the Entry point.  Include a Save & Cancel button.  After the Save operation, Requery the Form to update the results in the continuous section.

mx
0
 
rogerdjrAuthor Commented:
Ended up adding a "duplicate" data entry form to the header of the subform to make this work
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Isn't that what I suggested?  If so, why did you Accept the other answer?

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.