Hello once again,
Ok, so I have a question (big surprise)...How do I populate an unbound form with a recordset from a table? I tried searching previous threads, but the majority of the posts were regarding either continuous forms, or populating lists, so any help here is greatly appreciated.
My form needs to be unbound since it needs to be populated with a record from the tblMain, the previous data displayed and edited. Then, when the "submit" button is clicked by the user two actions take place: The first action is that the updated record over-writes the previous record with the same Key, and then that same recordset is added to another table, and then the objects in the form are cleared in order to update the next record.
I realize that having the form based upon a query written in access is the easier way to go, but this level of control over what happens with the data is necessary.
Ok, so I have a question (big surprise)...How do I populate an unbound form with a recordset from a table? I tried searching previous threads, but the majority of the posts were regarding either continuous forms, or populating lists, so any help here is greatly appreciated.
My form needs to be unbound since it needs to be populated with a record from the tblMain, the previous data displayed and edited. Then, when the "submit" button is clicked by the user two actions take place: The first action is that the updated record over-writes the previous record with the same Key, and then that same recordset is added to another table, and then the objects in the form are cleared in order to update the next record.
I realize that having the form based upon a query written in access is the easier way to go, but this level of control over what happens with the data is necessary.