performance between recordset and dlookup

[iccsi]

I have a report to support 2 languages.

I have 2 languages in the table and retreive depends on user prefer
language select.

The report has more than one hundred labels to print.

I would like to know to use Dlookup to assign label caption or using
recordset to get data in one shot and assign the label using tag
property.


I know that I can do some testing to compare.

If any one did test.can you please advise?

Your help is great appreciated,

 

[Mike Painter]

A recordset will always be faster but printing is slow even with fast
lasers.
Try the easier one first.
With only two languages, it might be just as easy to create two reports.

 

[iccsi]

A recordset will always be faster but printing is slow even with fast
lasers.
Try the easier one first.
With only two languages, it might be just as easy to create two reports.










- Show quoted text -

Thanks for helping,
The advantage of table is easier to maintain database.
If I need change any text then I can just update data without contact
user to update front end application.

Thanks again,