I have a variable which every time a report is run is stored in an unbound box. This no is sequential.However this no resets itself to zero every time you quit the db. Is there anyway of storing this value into a table and then referring from the table - is driving me ever so slightly batty any help - big respect

yes, create a table with one field (integer) that is your sequential report number. use a DlookUp() on the form that opens your report to place the number in a textbox. create an update query for the table that adds one to the sequential number and execute the query when the report runs.

hth,
al

note:
if the report can be run multiple times from the calling form, you will probably need to requery the textbox bound to the DLookUp()...

[This message has been edited by pcs (edited 09-08-2001).]