Subform Data Entry

[jhowells28]

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?

[mgstlucia]

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.

[missinglinq]

"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)>

[jhowells28]

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.