Thanks to pbaldy, I solved the first part of the problem here:
https://www.accessforums.net/forms/p...-box-8073.html
Lets say you have four text boxes and one attachment field on your form
One number data type (in table), we'll call it LookupNumber
Second is a number, ReturnNumber
Third is a date, ReturnDate
Fourth is text, ReturnText
Fifth is an attachment field
I am able to have the user specify the lookup number and look up the values with the following code:
Code:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Select * FROM TrackingTable WHERE [LookupNumber] = " & Me.[txtLookupNumber])
And then using code like:
Code:
Me.txtReturnNumber = Nz(rs!ReturnNumber, "")
My question is, how would I populate an attachment field like that?