Simple 1, update rs in VB6 for access
Hi, ive got a small problem, ive got a form which is set up so that all the fields are saved to a db when a save button is licked, its connected through and rs, i need the recordset to update when save is clicked so that when i move to the next form using the ".show" i need the values from the first form to show in the drop downs in the second. it all works fien if a save the first shut it down and then when i open it again the values are there.. is there a way to refresh the recordset.. below is the code ive been rying buit to no avail.
VB Code:
Public Sub UnloadAllForms()
Dim Form As Form
For Each Form In Forms
Unload Form
Set Form = Nothing
Next Form
rs.Update
End Sub
Re: Simple 1, update rs in VB6 for access
Quote:
Originally Posted by ricodstar
... i need the recordset to update when save is clicked so that when i move to the next form using the ".show" i need the values from the first form to show in the drop downs in the second. ...
Not sure what recordset has to do with either form so perhaps you can ellaborate and be as specific as possible.
:confused: :confused: :confused:
