Hello,
I think I have been a bit dumb. I have a form in my application that allows users to enter a new item (my DB is an expenditure tracking system). I have been developing this as I have been learning, so when I started out I created a second version of this form that is passed the ID of the item to be edited from a listbox on a separate form and allows the user to edit a tracked item. However, if I make a change to my "create item" form, I have to replicate those changes in the "edit item" form, which have realised is a stupid thing to have to do.
I'm thinking that I can use the "create item" form as the "edit item form", but am unsure as to the best way to do this. My "create item" form is set to be a data entry form, and the item is saved by means of a command button. I'm thinking I'd have to get the ItemID from the item selection form and pass this to the item creation form, but would this work given that that particular form is configured as a data entry form?
Is there a better way to do this?
Any advice would be gratefully received.
Cheers,
Phil