M
mike27
This seems simple, but I just can't map it out
I have a form showing records for a simple parts/drawing database. The form is based on the main table. I want to use a command button that will run a macro to automatically populate the part number field with a new autonumber from another table, but only when necessary. In other words, not every record will have a part number. But I need the ability to go back later & create a part number for the record if necessary. Can this be done with a macro? Perhaps there is an easier way to do it, like using a "option" button to disable/enable an autonumber field in the main table when an auto number is required? I appreciate any suggestions
Thanks
I have a form showing records for a simple parts/drawing database. The form is based on the main table. I want to use a command button that will run a macro to automatically populate the part number field with a new autonumber from another table, but only when necessary. In other words, not every record will have a part number. But I need the ability to go back later & create a part number for the record if necessary. Can this be done with a macro? Perhaps there is an easier way to do it, like using a "option" button to disable/enable an autonumber field in the main table when an auto number is required? I appreciate any suggestions
Thanks