Query to make copy of form and record

[banpreet]

Hi guys, I know I have been posting a lot because trying to get things done before Christmas. But thanks for all the help so far!



I would like to make a query that will be linked to a button on a form, that when clicked will create a copy of the form in a new tab or same tab but show up as another record in the table with the same information. But the only field that changes is the revisions field which default value is 0. I would like this field to add 1, so it would go from 0 to 1, then if revised again, it would go to 2, creating another record in the table. Then there is another field in called test status which is a drop down which value is "Final". I would like this to go to the value "Draft." So basically user clicks the button and it creates the same form all same information but the revision field goes up by one number and the test status goes to draft, which creates a new record in the table the fields are linked too.

Thanks!

[banpreet]

I think I figured out the first step, I made an append query for the table to create a copy of the record, but how do I do the revision part and test status part? Thanks

[pbaldy]

Your append query can have hard-coded values for a field. Put "Draft" in there.

[banpreet]

how about the revision field, and do I just put "Draft" in the criteria field? Thanks!

[pbaldy]

You can do it with any of the fields, and the value would go in the Field row. Access will add an alias, so it will look like:

Expr1: "Draft"

In an append query the alias is never shown to the user, but you can change it if you want.

[banpreet]

pbaldy how do I do this for draft field and update the revision field by adding 1 to it? how do I do the expr?

[pbaldy]

Revision + 1

[banpreet]

how do I type both the fields in the query, sorry I need step by step, where do I first put the "expr1" (the field name is Document Type) the table is called TR_Master, and the values for the document type I want it to default is "Draft". Where would I put all this in the query and how do I do the revision field and where do I type "Revision + 1" in the query. Thanks!

[banpreet]

anybody trying to give me a step by step, sorry im a noob at queries