you dont extract data by cycling thru form rows,
extract it in bulk, (to excel) via Transferspreadsheet....
(you didnt say how to extract it, and what to: excel, text...)
but, you can take if from the text box: msgbox txtBox
You don't paste an entire record into 1 text box,
You can run an append query to copy 1 record,
Or copy 1 field,then put into another field; txtBox2=txtBox1
SVar = txtBox1
'Move to another record,
make a form that shows all data from a table. (usu a continuous form)
then put the 2 text boxes in the form header.
when user fills in the search boxes, user clicks SEARCH btn, that filters the data using the code ( CLICK event)
dim sWhere as string
sWhere = "1=1"