Visual Basic&database, Viewing newly added records

Viewing newly added records

Author	Message
David Mize, Sr #1 / 4	Viewing newly added records When I add records with a form and then Hide that form and show another form which accesses the same table the newly added record doesn't show up. I'm using Recordset.Add and Recordset.Update when adding. DWM
Thu, 01 Nov 2001 03:00:00 GMT

Rgtf #2 / 4	Viewing newly added records Quote: >When I add records with a form and then Hide that form and show another form >which accesses the same table the newly added record doesn't show up. I'm >using Recordset.Add and Recordset.Update when adding. What about doing a Recordset.Refresh? RGT
Thu, 01 Nov 2001 03:00:00 GMT

David Mize, Sr #3 / 4	Viewing newly added records I had tried that and it didn't work, but I found out what does... just do a RecordSet.MoveFirst when I open the browsing form. DWM Quote: >>When I add records with a form and then Hide that form and show another form >>which accesses the same table the newly added record doesn't show up. I'm >>using Recordset.Add and Recordset.Update when adding. >What about doing a Recordset.Refresh? >RGT
Thu, 01 Nov 2001 03:00:00 GMT

Tim #4 / 4	Viewing newly added records Have you looked into the cursor type your using? Quote: > I had tried that and it didn't work, but I found out what does... just do a > RecordSet.MoveFirst when I open the browsing form. > DWM > >>When I add records with a form and then Hide that form and show another > form > >>which accesses the same table the newly added record doesn't show up. I'm > >>using Recordset.Add and Recordset.Update when adding. > >What about doing a Recordset.Refresh? > >RGT
Thu, 08 Nov 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]