update record after query

[Gavler]

I have a database for clients that recieve foodbags weekly. I conduct a query
based on social security number to see if they have a record. If they do, i
only want to change the date to relect the current date in the record and
then save the new record without losing the old records, or just add the new
date and have all the other information in the record remain the same. Any
help would be appricated, because now we are inputting all the same
information into the database everytime the client comes in to get food, but
the only new information is the date.

 

[Tom van Stiphout]

On Thu, 28 Feb 2008 04:45:01 -0800, Gavler

Create a form based on your data.
Go to the SSN field and hit Ctrl+F to search.
If the record is found, change the date field manually or with a
button (Me.txtSomeDateField.Value = Date() )

-Tom.

 

[Gavler]

Thanks Tom,
That did work, but it failed to save the old record in the table . It saved
the new date in the old record, I am trying to save the old and new rocord
with the new date found with Ctrl+F

 

[Tom van Stiphout]

On Fri, 29 Feb 2008 02:04:00 -0800, Gavler

You wrote:
"...or just add the new date and have all the other information in
the record remain the same..." which I took to mean 1 record.
If you want multiple records, I don't think the approach of making an
exact copy of a record and changing 1 field is appropriate db design.
Rather you may want a 1:M table with
ClientID, DateServed
You would then have a form with client information and a subform bound
to the new table for the dates.

-Tom.