By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Subform Data Entry

P: 8
I am using Access 2003. I have built an invoice entry form to enter invoices. It has a subform for the invoice detail. Everything works, but when I enter purchase order invoice information on the first line and finish it, it doesn't move to the next record or line; instead, it reverts back to the first cell in the first record entered. How can I make it begin another record within the subform?
Mar 12 '08 #1
Share this Question
Share on Google+
3 Replies

P: 30
I had this same problem. My problem was that I had my controls 'unbound'. I went to the properties of each control and pointed the control and changed the control source to the proper field.
Mar 12 '08 #2

Expert 2.5K+
P: 3,532
"when I enter purchase order invoice information on the first line and finish it"

What exactly do you mean by "finish it?" The behavior you describe would suggest that the recordsource is being requeried after you add a record. Do you have a "save" button? If so, you might look at the code behind it to see if there is a requery command.

Welcome to TheScripts!

Linq ;0)>
Mar 13 '08 #3

P: 8
When I say "finish it", I mean complete the information needed for the record. I have about six fields in the subdatasheet. Some of the fields pull in information entered in the parent form and others are left open for the user to complete. The last field is a calculated field that calculates quantity x price to get the total line amount. After this is calculated, I expect the cursor position to move down a line to the next record, but it doesn't. It just moves back to the first cell of the record I just completed. I will check to see if it is requerying somewhere.
Mar 14 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.