I have a form that has a lstbox control on it and a subForm on it that is set
up to look like a data sheet. In the subForm I have a field, bound to a
table, that has the default property set to =CurrentUser(). In that same
record is the field fldRNnotes.

Form1 is a prompt form that sets filter criteria for Report1.  Clicking OK
opens the report and closes Form1.  With help from my friends I have worked
out the code to do this.  
This is what I can't do - If Form1 has a textbox with a value 'abc', how do

Imagine...you have the database with the following form:-
I want to code a Get Item button to get the item from other job where the
quantityKitted is more than 0 and user should key in what job they want "to"
get the item from and to what job.