New Record In Continuous Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

New Record In Continuous Form

David Semon

4 years ago

I have a continuous form with Allow Additions = No, ORDER BY = testDate DESC and ORDER BY ON LOAD = Yes. I have a button that allows me to add a new record, but it adds it at the bottom. Is there a way to add the new record at the top of the continuous form.
I have searched multiple sites with no solution.
Thanks.

	Alex Hedley @Reply 4 years ago
Could a Requery after the Add

	Richard Rost @Reply 4 years ago
Basically... No. Unless you add some dummy unbound fields in the page header and add them to the table yourself then requery.

	David Semon OP @Reply 4 years ago
Thanks for your replies (Alex and Richard). I was afraid that was the case. I may have to get creative. Again, thanks for a superb teaching site.

	Richard Rost @Reply 4 years ago
So you're essentially looking for something like this...

	Richard Rost @Reply 4 years ago

	Richard Rost @Reply 4 years ago
Where you can type new records into the yellow fields at the top, hit the ADD button and then the new record gets added to the top of the continuous form? I just threw something together in a few minutes. I'll make a TechHelp video out of it. Gimme a bit.

	Richard Rost @Reply 4 years ago
How about this, David: New Record on Top

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View