[AccessD] Me.Requery doesn't work with ADO bound forms

jwcolby jwcolby at colbyconsulting.com
Mon Mar 12 07:59:50 CDT 2012


I am learning the ways of ADO recordset bound forms, IOW creating ADO.Recordset objects and 
assigning that to me.Recordset.  It is common in DOA bound forms to just do a me.requery whenever 
you want to requery a form.  AFAICT that no longer works, AFAICT it doesn't do anything.

Me.recordset.requery does does in fact requery the form however it leaves it with a #Name in every 
control.  So far I am having to rebuild the ADO recordset object from scratch and assigning the new 
ADO.Recordset object to me.Recordset to get this to work.

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it



More information about the AccessD mailing list