Keith
Registered User.
- Local time
- Today, 02:51
- Joined
- May 21, 2000
- Messages
- 129
I have two buttons to open a form, one to add records the other to edit records. The 'Add New Record' button also writes some of the information to a second table. The 'Edit Record' button only updates a field in the second table if that field has changed. Both forms are identical but with different code behind them. I have been trying to achieve the same, using one form. I am having difficulty in running the code to add or update the record in the second table depending if the form is opened as Add New or Edit. I hope this makes sense. Could someone point me in the right direction, or should I stick to using two forms?