Auto enter record after last field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two forms. One will automatically enter the record and give me a new
blank form to fill in when i complete the last field. On the other one I have
to click on the insert new record button at the bottom of the screen. How do
I make the second one like the first one?

Thanks
 
I have two forms. One will automatically enter the record and give me a new
blank form to fill in when i complete the last field. On the other one I have
to click on the insert new record button at the bottom of the screen. How do
I make the second one like the first one?

Thanks
Click to expand...

Set the Form's Cycle property to All records.
It's on the Form property sheet's Other tab.
 
Take a look at the Cycle property of each form and see if they are the same.
Sounds like you want it set to "All Records" in both forms?


Jamie
 
My form property is set to"all records," and after tabbing to the last field
to enter data, the form does not automatically advance to a new record to
enter data. In fact, even the control button at the bottom of the form (with
the asterisk) is grayed out.

I've checked as many applicable posts in search of a solution, but have not
found one that corrects this problem. I think one of the properties is not
set correctly, but for the life of me, can't figure out which property that
is.
 
After further testing, I think I figured out what I did wrong. As long as
the properties for the form is set to "all records," and data entry is set to
"no," the form will advance to a new record for data entry after data is
entered in the existing record. Apparently, in testing I tried to advance
to a new record for data entry without adding test data to the existing
record. Tabbing in this instance resulted in tabbing continuously/repeatedly
within the current record from beggining to end, instead of advancing to a
new "empty" record after tabbing to the last field in the current record.
Whew! Glad that problem has been solved.
 
Back
Top