Tabbing in Subform

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

Guest

This is probably SO easy for someone. PROBLEM: After the first record is
entered in the subform (in datasheet view) you can hit Enter or Tab to go to
the next line (new record). But instead, the entry point automatically jumps
back up to the first field in the first record. Also, if you continue
without tabbing to the "new" record, instead of going DOWN to the designated
"new" record that's marked with an *, it adds a new record above the first
one.

After the first and second records are entered successfully, everything goes
as it should.

What's going on?
 
This sounds like a property setting issue for the form's
cycle property. It's found in the form's code module
window. Select View, Properties if you don't already see
the property box. Click the grey square just above the
vertical ruler on the left hand side of the form design
window. Select the Other tab the property box and you'll
see the Cycle property. Should the setting be All Records?
Good luck.
Geof Wyght
 
Thanks Geof. When I checked the Cycle Property settings on the subform, it
IS set to All Records. That's the proper setting according to the rules for
what I want to do - which is data entry. I already checked the Tab Order and
everything's OK there. Can you think of anything else?
 
My guess is that there ia a *re-query* action in your Subform since after a
re-query, the first Record / row of the newly re-queried form Recordset
becomes the current Record.

You will need to check your code for Requery.

HTH
Van T. Dinh
MVP (Access)
 
Van - I very thoroughly checked all the code for the Subform and there is no
Requery action anywhere. I even searched for Requery (and Re-query) all over
the place and no show. Does it mean anything that the Masterform and the
Subform are placing data in the same table? The reason for the Master-Sub
thing was to eliminate the need to repeatedly input some data that was the
same in every record (a name, year, and location.)
 
This is really stumping me. Can anyone add anything? I've check the cycle
property (it's correct) and the "re-query" thing ( I hope I checked
everything) and neither one of them are wrong or present. It's an
aggravation of large proportion.

Thanks, everyone for your help.
 
You may have a corrupted form (subform). You may need to rebuild the form
and see if the problem persists. Or import all objects into a new, empty
database and try it again in the new database.
 
Back
Top