Stuck again!

[jonesy]

Hi,

I have a database that stores details of Drawings, Specifications, Projects etc. With regards to the drawings, I have a form that allows the user to enter drawing details, and use the various tabs to associate that drawing to one or many projects, specifications and CAD Data, and also enter the distribution history.

Every now and then, issue number x of a drawing gets superseded by issue number x+1. At the moment when this happens one of the users creates a new drawing record, and copies every detail about the old issue into the new one (drawing info, associated specs, cad and project, but not distribution which starts from new). They would then mark the older issue drawing as obsolete, which is just a check box on the form.

What I’d really like to be able to do, is have a button on the form somewhere that would create an identical record as the one currently selected except for distribution history which should be blank, issue number which should be incremented by 1, and issue date which should be current.

Does anyone know how to do this? I’ve attached a hugely scaled down version of my db, which I also had to convert to 97 to be able to post it, although I’m working in 2000 if it makes a difference.

Jonesy

 

[FoFa]

I would just use an Insert to create a new row from the old row in the DB with the changes you want, then requery your form to the new record. Easiest would be to create a APPEND query to do it for you, and run that from the button, then reposition the current data on the form.

 

[jonesy]

Thanks for the reply FoFa, would it be possible to elaborate a little please? I'm fairly new to access and I'm not entirely sure what you mean. If you could perhaps show me how you would do it by posting an amended version of my DB, that would be appreciated.