Hello All,
I have an unbounded form which is populated by a recordset like this:


Private Sub Form_Load()



Dim con As ADODB.Connection
Dim rst As ADODB.Recordset

Set con = CurrentProject.AccessConnection
Set rst = New ADODB.Recordset

With rst
Set
.ActiveConnection = con
.Source = "SELECT *,vendor.vendor_country FROM MRP INNER JOIN vendor ON vendor.vendor_ID = MRP.vendor_no"
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseServer
.Open
End With

' Set the form's Recordset property to the ADO recordset
Set Me.Recordset = rst
Set rst = Nothing
Set con = Nothing

END SUB



Private Sub Form_Current()

rep_no.Value = Me.Recordset!rep_no
edit_date.Value = Me.Recordset!edit_date

END SUB


there is also an attachment control on form and a attachment field in recordset.
the issue is how to bind attachment control of form to recordset.


Thanks in advance!