I have created a database which currently holds 300 records. Each record has a 6 fields to show allowable defects (size, colour etc).All 300 records will only have choice of 3 possible defect descriptions.
Is there a way of having each set of descriptions on 3 separate forms and with a click of a button on the current record in the database copy the data from the fields into he corrosponding fields of the current record.The aim is to prevent the user from having to repeatedly enter the same data into a number of records and also to be able to change a set of descriptions at the press of a button.( Sorry it is a bit long winded )
Is there a way of having each set of descriptions on 3 separate forms and with a click of a button on the current record in the database copy the data from the fields into he corrosponding fields of the current record.The aim is to prevent the user from having to repeatedly enter the same data into a number of records and also to be able to change a set of descriptions at the press of a button.( Sorry it is a bit long winded )
