Data from Form to Table

C

Cranky

Hello

I've read through similar threads but can't find the answer I need.

It's a 2-parter, I'm afraid.

I have a form for recording numbers of visitors to my office. The date
is set by a calendar control.

1: The first time I test the form's Save button, it works fine.
However, subsequent records using different dates are not recorded. EG,
08/06/05, all visits sent to the table correctly. If I go then try to
save 09/06/05, nothing happens.

The code set to the button is -

DoCmd.RunCommand acCmdSaveRecord

What have I done wrong?

and

2: If I was later to select 08/06/05 again, how would I go about the
form showing previously stored data and overtyping any amendments when
saved?

Thanks in advance

Steve
 
C

Cranky

Joseph said:
Just open the form and find the record (a number of ways of finding
records) then make any amendments you would like and either close the form
or move to another record and the changes will be saved.
Click to expand...

Trying to use a 'Save' button was partly an aesthetic thing, and partly
because the person using it is prone to overtyping data by mistake. I
know that if she had the record navigation buttons she would overtype
some data. I know how facetious I sound saying that, but it's true. I'm
looking for a solution where she would have to consciously save the
current data - there would be an 'are you sure?' type messagebox as
well.

Thanks

Steve
 
Top