Lost with form design

[Jaymin]

Hi all,
I need a little help with form design, I have several forms where i enter information eg. a enter staff form, delete staff form. is the best way to have a seperate form to add staff and a seperate form to edit/delete the staff, or should i just have the one form that does the both. or should I use one form and use VB to alter the properties of the form to do the above.
Hope this make some sence.

 

[CJ_London]

either way is OK tho' there is less maintenance in having one form.

Only reason I can see for having different forms is if you want them to look completely different - e.g. new/edit is a single form with all the fields, whilst delete is a continous form showing just names - although even this can also be handled with vba

 

[Wiz47]

Hi all,
I need a little help with form design, I have several forms where i enter information eg. a enter staff form, delete staff form. is the best way to have a seperate form to add staff and a seperate form to edit/delete the staff, or should i just have the one form that does the both. or should I use one form and use VB to alter the properties of the form to do the above.
Hope this make some sence.

Generally speaking, I like to use one form for both. Typically I'll have a combobox to select the record I want to bring up. Once the record is visible (bookmarked) I can edit at will. I also have a separate command button to delete the current record.

Works for me ...