Populating attachment field based on text box

[RuralGuy]

The Northwind db also has a number of good examples. Post when you need assistance again.

[justinwright]

Okay, so the Northwind Db was a help with other stuff I was curious about, but I didn't find much on what I needed. I did, however, find this:

http://blogs.msdn.com/b/access/archi...ent-field.aspx

That someone pointed me in the direction of. It seems like, though, that this is for external file storage.


As another aside, through hours of searching I found something like:

Me.AttachmentControl = rs.Fields("ATTACHMENT")

Which gives me "Error 438: Object doesn't support this property or method."

and

Me.AttachmentControl = rs!Fields("ATTACHMENT")

Which gives me "Error: Item not found in this collection."

and

Me.AttachmentControl.Value = rs.Fields("ATTACHMENT")

Which gives me a different type of error box that says "Method or data member not found."

And

Me.AttachmentControl.CurrentAttachment = rs.Fields("ATTACHMENT")

Which gives me a "Type mismatch" error.

There is an attachment there called attachtest.txt.

This might be a long short, but I feel like I'm on the right track with those particular parts of code (though I could be completely wrong). Based on that, anyone have any ideas? I'm really hitting a roadblock here, despite hours and hours of testing and searching.

EDIT:

I've found the following methods that seem relevant:

CurrentAttachment
AttachmentCount
FileName
FileType
FileURL
OnAttachmentCurrent