Attach a picture file in a form

[Guest]

I have two tables: properties (pk - property_id) and pictures (pk -
picture_id; joined to properties on property_id). I have a form set up to
enter data about a property (address, etc), but I am looking for a way to
enter - or attach a picture file - in the pictures table and will capture the
new property_id created by the record. The only purpose the pictures have
will be for reporting. My understanding is that it is better to store the
pictures as a .bmp.

Can I create a subform within my 'property' form that will allow me to
attach a picture file as a bitmap, create a pk within the table and pull in
the property_id?

Thanks.

 

[Penguin]

Check this link:

http://www.mvps.org/access/forms/frm0044.htm

and this link:

http://www.lebans.com/image_faq.htm