DLookup Compared to Recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it correct to use DLookup only when you need a specific value and use
recordsets when you need to manipulated the data (update a record, etc.)?
 
Yes, you usually use the DlookUp when you want to retrieve a value of one
field from one record, and recordSet when more then one record involved.
There some points of difference between reordset and dlookup

RecordSet
1. Can be updated
2. Retrieve more then one record, and have the ability to move between records
3. Can bring all the fields in the record
4. Can't be used as a source of a field in a Form/Report/Query

DlookUp
1. Can't update
2. Retrive only one record
3. Usually used to bring the value of one field
4. Can be used as the source of a field in a Form/Report/Query
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pop up form to open one record with dlookup 1
A theoretical question: how best to manage perpetual recordset needs? 25
dlookup and dao.recordset 4
Which is more efficient? 4
Another Easy Access Questions 5
Lookup a specific field in a specific row in a recordset. 3
Simplest way of using ADO Recordset to replace DLookup command 4
DLookup and Nz 0

Back
Top