Is it possible to place a text box within a form and write hard code to pull data from a table vs creating a query? example: table name: tblnscnumbers record source within table: yesterdaynumbers.

You could use the DLookup() function (if I understand your question) ...

RDH

You can use DLookup() as the Control Source of the Text Box to gather a single piece of data from a table or query... This article will help you with the DLookup() syntax...

This just one way to do what you want...

hth,
Jack

Thanks! that works.

Ricky and I were glad to be of assistance...

Jack