NotInList Question

[xRoachx]

I've seen multiple posts on methods used to add values to a combo box. The
two ways I've seen have both used recordsets, but one way used SQL (INSERT
INTO) and the other used recordset methods (rs.AddNew, rs.Update).

Is it better, that is, is it more efficient, to use SQL rather than the
recordset methods, or is this simply a coding preference?

Thx in advance!

 

[Roger Carlson]

I suppose SQL is more "efficient", but when adding only one record, the time
difference will be indistinguishable to the user. I'd say it is a coding
preference more than anything.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L