open form to add new records - Open Form to New Record in Microsoft Access


	Back to Open New Record Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

open form to add new records

Robert Stott

2 years ago

I am using DoCmd.OpenForm "frmEditReader", acFormDS, , , , acDialog & DoCmd.GoToRecord , , acNewRec to open the form to a new record, but I would like to just have the recordset consist of just the new records that add (there are 10,000 records).

In my reaseach a I came across - DoCmd.OpenForm "frmAudioBook", , , , acFormAdd. This works but plays navic with my record navigation buttons. I endup having to use Ctl S or move to the first record to save it. I also set the Data Entry = yes.

It seems that I have used many application over my life where the from is just for data entry but I do wish to be able to entry multiple new records.

Any suggestion would be appreciated - my research is limited by how I ask the question.

	Alex Hedley @Reply 2 years ago
What's the issue with saving the record when complete?

Robert Stott OP @Reply

2 years ago

when open the from to a new record the record set includes 10,000 records. I am trying not have to deal with the 10,000 - if I hit the wrong navigation button then I am dealing with all the records; you have to hunt your new record to complete it. If I am entering say 10 new records, and I want to be able to just look at those 10 records it would be great. The saving thing is a work around for the code that I trying to use.

If I select one record to open in forms recordset (there is one record in the recordset and I can add as many new records as I want, but only the original record and the new records are in the recordset.

So is there a way to (1) open the from so that no records are in the recordset (even though there is 10,000) (2) work with just the new records I entering (3) close the form and have the new records added to the total record set?

	Kevin Yip @Reply 2 years ago
You can set a WHERE condition for DoCmd.OpenForm to restrict what records to show in the form. If your form has an autonumber primary key ID field, then find out the highest value of that field (say, 1000), then open the form with a condition that shows only records that have an ID greater than 1000: DoCmd.OpenForm "MyForm", , , "ID >= 1000"

	Robert Stott OP @Reply 2 years ago
Thanks Kevin! That works along a small change in the Rerecord Navigation buttons. Simple but Nice!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Open New Record.

Next Unseen

New Feature: Comment Live View