copying data to forms

H

Halocarbon

We are using Access to input chemical samples into the database. Eash sample
is given a unique Sample ID number (assigned by access). The users type in
this number to retrieve the information for their sample. How can I make a
form that will allow them to retrieve the information they need and update it
but not overwrite the original information? (Example: They need to type in
the results for sample number 5. Once the results are put into the database,
they realize they typed one of the results wrong. I want them to update the
results but I do not want the wrong entry to be deleted or updated. I want a
new record to be made with the correct information, yet we can still see the
wrong entry.) I use a query to bring the information into the form but when
the changes are made it changes the original entry. How can I make this not
happen? Thanks.
 
K

Kevin3NF

You need ata minimum two tables...one for the sample, and one for the
results. This would be a one-to-many relationship. You would probably want
to create a subform based on the Results table and link them together on the
sampleid from your sample table (which will also be in the Results table)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
H

Halocarbon

I was able to do it by making a very long complex macro. Now i would like to
hide all the flashing while the macro runs. Is there a way to do this?
 
J

John Vinson

I was able to do it by making a very long complex macro. Now i would like to
hide all the flashing while the macro runs. Is there a way to do this?
Click to expand...

I don't see why you need ANY macro. Kevin certainly didn't suggest
one, and I can't see how a macro would help you at all.

Please explain your table structure (a simple one to many is all I
see) and what the macro is supposed to accomplish.

John W. Vinson[MVP]
 
Top