data entry = yes 2

[DrillMonkey]

I have a form sub form, I have set the properties for both form and sub form to data entry = yes the sub form acts as expected with no records showing to the user but, the main form does not. The main form can scroll back one record, it will eventually not show any records like the sub form if I close it and reopen it.

 

[ProgramError]

change it to no

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[SeeThru]

Even with data entry on, I think you can always see records you have added since you last opened the form.

Try removing all the navigation buttons, and using a command button to go to a new record. No back button means that cannot go to an earleir record.

 

[missinglinq]

SeeThru is correct. When a form is opened with DataEntry set to Yes, an empty recordset is created. You can add a record to this recordset, add a second record, then go back to the first record. You can even edit this first record. His suggestions about deleting the native navigation buttons and using a custom Add button good.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[SeeThru]

Oh, and you may want to captue the pageup/down keys as well, and maybe the mousewheel.

One other posibility would be a save button. Use a cancel event to prevent moving off the record, no matter how it is tried, and have a save button that moves to a new record.

 

[DrillMonkey]

Thank you both for your suggestions, it was the main form I was concerned with, I noticed that it would scroll back with the mouse wheel like you suggested. But the subform acted as it should..All is well thanks again.