wow does you guys ever use vba in access?
doing this is very simple use something like this code example... this is just a example
when you have the form open
open it and have a WITH statement like this
that quote is my own i dont take other peoples code
this way when you click the...
you could use user id which would be set up as a key field in a table then use a query or recordset to retreive the newest data inserted in the fields and the populate the fields right?
so some thing like
that should fill in the boxes with the most resent data if i am correct
umm y dont you just use me!txtfield?
ok you can do something like this?
cmdfillinhisform_click()
docmd.openform "movewindow"
with frm
.formfields("bookmark/name of text box goes here").result = me!"name of txtbox on your preveous form"
...
end with
frm.movewindow.visible = true
end sub