We have a form that is used as a work order form. The form also has a sub-form. Both the form and the subform have several fields in their record sources. Now we also want to have a quotation process. The quotation form will look exactly like the work order form but of course will have it's own record sources.
What I'm trying to figure out is this... can I use the same form/subform for both the quotation and the work order? What I picture is two command buttons on a form. One of them opens the form/subform for quotes and the other one opens the form/subform for work orders.
But is there a way to dictate which record sources are to be used for the form/subform depending on which command button was clicked via VBA code?