Access command button: Add a New Record that has the same value as the current record.
My form is based on a table that has many order numbers (not unique) and many item numbers (unique). My access form is a single form where I can view one item number at a time. Id like to introduce a new command button which adds a new record that has the same order number as the record Im currently on. How can I achieve this?