in attached db, frmDocuments, is a tabbed control with a pgVersion. (credit and thanks to Mike Smart for the help to get this far)
A command button "Add new Version" currently creates a new version with Version and revision number at 0 and 0.
I want the new version records to have the Version and REvision fields to be one of two possibilities based on choosing Major or Minor.
All I have been able to accomplish is a calculated field that provides the new value choices based on the current record values. I want the Major or Minor button to add a new version with the calculated values populated into the table for VErsion and REvision.
How do I go about doing this?
thanks
AmyDocumentControl_PB.zip