combobox column property or dlookup

[Guest]

Could someone give me a short treatise on whether it's best to use dlookup or
the combo box column property to populate text boxes on a form with the data
in other columns of the cbobox and the pros and cons of each approach

much appreciated
chris

 

[Guest]

Hi Chris,

If it is data that exists in the table/linked to the table that is
populating the combo box, you might as well use the column method, as that
way your query is run once, and you are using the data that you have already
returned. Each dlookup uses resources, so if you have 5 fields each with a
dlookup, you are basically running an additional 5 queries every time the
record changes.

Hope this helps.

Damian.

 

[Guest]

Great. Thanks for the info Damian

Chris

Hi Chris,

If it is data that exists in the table/linked to the table that is
populating the combo box, you might as well use the column method, as that
way your query is run once, and you are using the data that you have already
returned. Each dlookup uses resources, so if you have 5 fields each with a
dlookup, you are basically running an additional 5 queries every time the
record changes.

Hope this helps.

Damian.