turfbult
Aug 5th, 2000, 06:11 AM
I have 2 forms (frmclient and frmquote) and 2 tables in a database.... client & quote
in the formload of frmclient, I open a connection and get a default record set rsrecord.open "select * from client". I also bind all my textboxes to the fields in the table!!
now I want the user to enter all info into the client screen and then click the save button to save all entered into the client table.... I use rsrecord.addnew - but this doesn't work. IE. When the user clicks the save button all entered must be saved to client table and then the quote screen opens from where I want to save quoting info into the quote table once save is clicked. I have navigation buttons "back" and "next". If I'm in the quote screen I want to be able to go back to the client screen and see what was entered.
Please help... I know this might not make a lot of sense, but I'm just starting out in VB and am really battling.
Thanks
in the formload of frmclient, I open a connection and get a default record set rsrecord.open "select * from client". I also bind all my textboxes to the fields in the table!!
now I want the user to enter all info into the client screen and then click the save button to save all entered into the client table.... I use rsrecord.addnew - but this doesn't work. IE. When the user clicks the save button all entered must be saved to client table and then the quote screen opens from where I want to save quoting info into the quote table once save is clicked. I have navigation buttons "back" and "next". If I'm in the quote screen I want to be able to go back to the client screen and see what was entered.
Please help... I know this might not make a lot of sense, but I'm just starting out in VB and am really battling.
Thanks