Show two different records from same Record Source

[Greyowlsl]

Hi,

I am trying to create a textbox that will show a document number of the last record so when a user clicks add new document he/she knows what document number to enter in next. It must not involve the user looking a subform with the document numbers on it.

Thanks for your time,

Leon

 

[Greyowlsl]

Hey,

Thanks for your reply, but ive worked out another way more suited for my db

,Leon