Problems with Access Form - jumping to previous record after entering data

  • Thread starter Thread starter SHAWN
  • Start date Start date
S

SHAWN

Hi,

I've got a form that is based on a large query and has about 50 bound
controls and two unbound - a combobox (used for displaying a record by
selecting a unique value from it) and a memo field where users write
there comments.

The memo field used to be a bound control as well, but then one of the
users (this is a FE/BE situation), told me that after she entered a
comment and pressed ENTER, it jumped to the previous record and the
value she'd just entered was there as well. I opened the query and
sure enough - I saw that value in both records.

I thought it was the memo field that was playing games here, so I made
it unbound. The problem seemed to have gone away.

Now, a different user told me that after she entered a comment, the
form jumped to the previous record and the comment was already there,
and some values that she entered for the original record, were there
as well, i.e. the comment from an unbound control, and two values from
bound controls for record A were copied to record A-1 somehow.

Could anyone help me as to what I'm doing wrong. I use Access 2000 -
Win2000.

TIA
 
if you're stilling have trouble and nobody else has helped
you, you're welcome to email a copy of your db to me, and
i'll try to find the problem. if you decide to do this,
then copy the db, remove proprietary data (put a couple
fake records in the table(s)), COMPACT the db, zip if
necessary to under 2 MB, and send it along.
 
I don't why the text box would copy to the next record. However, if it is
un-bound, then you should check your code.

However, as for hitting enter, and moving to the next record, that would
make a lot of sense, since when on the last text box on a form, tab, or
enter will jump to the next record. However, you can change this behave in
the forms "other" type. Simply set the forms cycle property to current
record. I do this virtually ALL of my forms, since it causes so much
confusion.
 
Thanks guys for your responses.

Tina. I tried to send you my db but got it back as apparently there is
a problem with your account.

Is there any other address I can send it to?

Thanks again.

SHAWN
 
Back
Top