Slow database: Alternative to DLookup

[DajTwo]

Access 2003: Front end - back end'

The opening menu displays the version number of the front end in a text box with the following code

="Version Number ... " & Nz(DLookUp("[ver_clt]","[tbl_version_client]"),"????")

There is always only one record in that table.

In my attempts to fix a chronic slow database, I am seeking alternatives to this function to display the content of that unique record.

Thanks

If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[dhookom]

Try a subform bound to tbl_version_client with a text box with a control source of:

=Nz("Version Number ... " + [ver_clt],"????")

Duane
Hook'D on Access
MS Access MVP

 

[DajTwo]

Thanks for the reply.

I have tried several times to get it working but I seem to be missing something..

Ill try again on Monday..

Thanks!!!!

If I did not say it before, I really appreciate the time and expertise of the users on this forum.