Copying Form but only certain records

[Vu Tran]

Have a question. I have a form with specific project
information which needs to be updated every month. Is
there a way, on command (a programmed button?) to
automatically insert a new record with the current date
but only specific fields copying the data while specific
other fields going to zero?

Thanks!!

 

[Rick B]

yes. Create a button with code on it. Look up the record you wish to copy.
In the onclick property for your button, store the fields you wish to copy
into variables. Move to a new record, place the contents of the variables
into the fields you wish. Set the focus to the field you wish for the user
to start with.



Have a question. I have a form with specific project
information which needs to be updated every month. Is
there a way, on command (a programmed button?) to
automatically insert a new record with the current date
but only specific fields copying the data while specific
other fields going to zero?

Thanks!!