Tabbing through fields in a form

[loulav]

Hello

I've created a form which has a date textbox. After I type in the date and
press the tab key to move to the next field, the date that I just typed in
disappears and the next record comes up, ready for me to fill in. When I
check the corresponding table, I see that the date appeared in the table. I'm
wondering if anyone knows why the record is being uploaded as soon as I hit
the tab key to move out of the date field, which is the first field in the
form. Thanks for any help

Lou

 

[Guest]

Two things come to mind:

First you need to go to the "Other" tab of the properties of your form and
set the "Cycle" property to "Current Record". While you are there with your
cursor in this property, press F1 and you can see what affect this will have
on your form.

Also, it sound like your data field may be the last field in the Tab Order
of your form. With your form in design view, right click and select the Tab
Order option. Set the tab order to the desired order.

 

[loulav]

Thank you, you solved my problem. I'm learning more every day.
Thank you again

Lou

Two things come to mind:

First you need to go to the "Other" tab of the properties of your form and
set the "Cycle" property to "Current Record". While you are there with your
cursor in this property, press F1 and you can see what affect this will have
on your form.

Also, it sound like your data field may be the last field in the Tab Order
of your form. With your form in design view, right click and select the Tab
Order option. Set the tab order to the desired order.

Hello

[quoted text clipped - 7 lines]

Lou

 

[Guest]

Your very welcome.

We all learn something everyday, from each other.

--
HTH

Mr B
askdoctoraccess dot com

Thank you, you solved my problem. I'm learning more every day.
Thank you again

Lou

Two things come to mind:

First you need to go to the "Other" tab of the properties of your form and
set the "Cycle" property to "Current Record". While you are there with your
cursor in this property, press F1 and you can see what affect this will have
on your form.

Also, it sound like your data field may be the last field in the Tab Order
of your form. With your form in design view, right click and select the Tab
Order option. Set the tab order to the desired order.

Hello

[quoted text clipped - 7 lines]

Lou