Cancel form navigatioon

[funkygoorilla]

Hi,
I am creating a form for inputting data to a table, and when the I tab through the fields, after I get to the last field, data from the table shows up? Its like when you tab through the form, it searches the table that the form is supposed to be entering data into. Is there a way to stop this?
Thanks,


FunkyG

[June7]

After the last field the form is cycling to another record. You can either open the form filtered to a single record or set the form Cycle property to CurrentRecord.

[funkygoorilla]

Hi, thanks for your reply. Although it doesnt make sense to me why a form would cycle through the database, I set the property to Current record source and it works like a charm. FunkyG

[June7]

It cycles through the database if the form RecordSource has multiple records and the form is set to allow cycling all records. I seldom use that setting but I do have a couple of forms configured for this behavior. When users are editing a bunch of existing records, allows quick movement to next record.