I have a form with two subforms on it, and up till now I have made it unbound. After the user selects the record he wants to view from a combobox I then set the main and sub forms to stored procedures and set the imput paramters accordingly. That works great for viewing, but now I need to add a new record...How?!
I tried to set the main form and subforms to the actual tables when the user pressed a "new" button, but that brings over all the data and that takes too long. If I just had one table then I would probably leave it an unbound form and add the new record using ADO, but I don't know how to do that with the subforms.
Any suggestions on how to add new records without ataching to the tabels and bringing over all the data?
PS. this is in an Access ADP with SQL2000
I tried to set the main form and subforms to the actual tables when the user pressed a "new" button, but that brings over all the data and that takes too long. If I just had one table then I would probably leave it an unbound form and add the new record using ADO, but I don't know how to do that with the subforms.
Any suggestions on how to add new records without ataching to the tabels and bringing over all the data?
PS. this is in an Access ADP with SQL2000
