sub-form problem

[Guest]

i have three field setup in a sub-form: date, service, price.

when i enter the date and press the tab key to skip to the next field the
cursor jumps back to the date field, press it again and it finally moves over
(this happens with each field). Get to the price field - enter the price and
press the tab key to skip down and enter a new date and the cursor skips back
to the first entry and will not allow a second entry.

what should i check?

thanks
martin

 

[Allen Browne]

Open the form in design view.

Make sure there is nothing in the Timer event of the form.

Choose Tab Order on the View menu, and make sure the order is correct.

Make sure the Tab Stop property of each control is Yes.

Make sure the Cycle property of the form is set correctly. It should read
"All Records" if you want to be able to tab into the next record.

If there is anything in any events of the controls, temporarily remove it to
see if that is the problem.

If any of the controls have an Input Mask, or if the field in the table has
an Input Mask, remove that too.

Hopefully you will have identified the culprit by this point.

 

[Guest]

Hi - if the date field is the last one on your form look in Tools / Options /
Keyboard -check what is set in move after enter. Hope this helps,

 

[Guest]

Thanks for the response guys.

this has corrected the problem of the cursor moving back and forth between
fields, however, i still cannot get to the next the next line to type a new
entry.

I have changed the option "move after enter" to move to next record but the
cursor still jumps to the first record and will not allow for new entry.

I have checked the form properties, sub-form properties, date, service and
price properties all are set to accept data entry.

i can try to use the tab, enter, cursor keys even the new entry button on
the scroll bar but the cursor always jumps back to the first record.

any other ideas??? PLEASE

martin

 

[Allen Browne]

Which suggestion solved the previous problem?

Is the form's Cycle property set to All Records?

Is there code in any of the events of the form or its controls that could be
affecting the cursor movement?

 

[Guest]

i changed/corrected everything that you sugguested. the problem it cured was
the one where the cursor would jump between the fields ie: from the date
field to the service field the cursor would jump back to the date
field...this is fixed.

i have checked the event procedures in the form, sub-form and each of the
fields and have not noticed and codes in any of them. ( i am a novice and
have not advanced to this stage yet).

to clarify ... my problem is i can view the previous entry (entered b4 i
started having this problem) but when i tab from "date" to "service" to
"price" i'm fine but tab once more to enter and new record and the cursor
jumps back to the date field of the first record. i have tried using the
tab, enter, cursor keys and even the new record button on the scroll bar and
i get the same result....the cursor jumps back to the date field of the first
record and will not allow new record entry.

STUMPED!

 

[Allen Browne]

Sorry: that does not suggest any new possiblities for you.

 

[papa]

i changed/corrected everything that you sugguested. the problem it cured
was
the one where the cursor would jump between the fields ie: from the date
field to the service field the cursor would jump back to the date
field...this is fixed.

i have checked the event procedures in the form, sub-form and each of the
fields and have not noticed and codes in any of them. ( i am a novice and
have not advanced to this stage yet).

to clarify ... my problem is i can view the previous entry (entered b4 i
started having this problem) but when i tab from "date" to "service" to
"price" i'm fine but tab once more to enter and new record and the cursor
jumps back to the date field of the first record. i have tried using the
tab, enter, cursor keys and even the new record button on the scroll bar
and
i get the same result....the cursor jumps back to the date field of the
first
record and will not allow new record entry.

STUMPED!