I have a form with an combobox (cboID), autofilled textboxes (txtsubmittedby, txtextension, txttype) filled by "=cboID.column(1), =cboID.column(2), etc.", and empty textboxes (txtassignedto, txtassignedextension, txtassigneddate) to type info into. I have the form based on a query with all of these fields in it (all from External table except "assigned" fields from Assigned table). The combobox is linked to an autonumber field.
1. How do I have all the information save into a table (the autofilled fields and the assigned fields) with each record?
(there should be a different autofill with each number in the combobox)
2. Go to a new record while saving the current record (i.e. a commandbutton)
I have Access 97.
I appreciate any help.
1. How do I have all the information save into a table (the autofilled fields and the assigned fields) with each record?
(there should be a different autofill with each number in the combobox)
2. Go to a new record while saving the current record (i.e. a commandbutton)
I have Access 97.
I appreciate any help.