New record overwritten on old column

[chooriang]

Hi,
I just made a form with microsoft access and insert some text box.Then I
open the form in the form view and insert some data into the text box.But
when I was trying to insert new record,the cursor didn't automatically move
to new column,the field contain the old data ( previous insertion ).So,when
I type the new data,its overwritten the older data.

Anyone wanna help.It would be much appreciated.

regards,
'

Cho

 

[Guest]

Hi

Have you made a table to store the data ?

If you have just made a "stand alone" form it will be unbound - this means
that that "data" will only be stored on the form and will be over written
when you type in new information.

You may need to look at the very basic use of access or ask for some advice
from someone who has alread some experience in using access.

 

[chooriang]

Thank's Wayne for the update.
I have made the table before.Just like you say when my form viewing in
design view I see the word 'unbound' in the text box.And then what should I
do.Would you like to tell me.Or any other better idea?

Regards,

Cho

 

[chooriang]

I mean I have created some column in my table before and then added new
column by making the text box.please advise

Cho

 

[Guest]

Hi

You can "bind" the various sections of the form to a table but it may be
simpler to start with the table.

1st
On your table you should a unique "pointer" for each record. Many people
use access to help with this by using an "autonumber" field. If you have not
done this yet open the table in design view and insert a new row at the top
of the grid and place somethin like RecordID row. Set the format as
Autonumber and right click this and select Primary.

Then ensure that all the other information you need is in the table and then
open the table to have a look and just check that it looks OK.

If you are happy with the table - close it and select the New Object tab
(it's on the top of the screen). Select Form Wizard and follow the
instrcutions. Have a look at your new form and if you are happy with it then
use it as it is. If you want to change the design you can open the form in
design view and make changes.

MOST IMPORTANT - if you are using the data base for anything important or
for work I would really suggest you seek some advice or maybe take a training
course BEFORE starting to use access.

Access is a great programme but it isn't like Word or Excel as you can't
really just open it and start using it without just a little knowledge.

Hope this helps

 

[chooriang]

Hi wayne
Thank's again for the response
I have done everything you said in your previous message.I have the primary
key,Build the form with form wizard and edited the lay out.But the problem
is the new value in my text box is overwritten to the old value.When I see
the properties of the text box,"control source" was not specified.Is it
correct.
Wish you like to help.

Regards,
Cho