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
.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
End With

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


Private Sub Form_Current()

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


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!