I'm making a booking program in vb6 using an access2000 db. i have two main forms on my project: booking form, and member form. I'm working on the member info form and i've made a data environment so that i can talk to the db.
ive made a big select cmd in DE so that all the memberinfo is shown in the text boxes i have. this way i can get the relations right(example NO shows Norway).
When i go from my menu to the member form i get the first member in my boxes. But when i go back to the menu (with unload me) and then go back to the form, all the boxes are blank. (i solved this by using me.hide) What is happening to the recordset?
Next problem is how to check if a recordset is open or closed. (deMedlemmer.rstblMedlemmer.open = false ?)
Next problem when i add a new member it goes into the rstblMedlemmer recordset. But the rscmdMedlemmer sql recordset doesnt get updated until i exit the prog and run again...
please help me.. the program is due in one month.
