Problem about Multiple Data retrieve to a form from a table.

[tinyappz]

Did you actually bind the forms to the tables? Did you set the subform container control Master/Child links properties?



How are you moving to next record?

Thank you for the reply,
How to bind the forms to the tables ? container control Master/Child links properties ? can you explain a bit more.

[June7]

Creating bound forms is basic Access functionality. Access Help has guidelines.

Basically, set the form RecordSource property to a table or query or SQL statement.

Setting the Master/Child links is described in the referenced tutorial.

[tinyappz]

I have learn many things thanx June 7. still there few issues ,
as in attached image i need to insert small images for each product using insert object into picture field , when i insert bmp image it is not displayed ,

it should be displayed in Oder form when making the invoice , see the below order form.

[June7]

Are you using an Attachment type field?

Are you using an Image control?

Works for me.

[tinyappz]

It is image control ..

[June7]

Is it Attachment type field?

I cannot replicate the issue. But from the image posted it doesn't look like it is an Attachment type.

If you want to provide db for analysis, follow instructions at bottom of my post.

[tinyappz]

db is large then 2mb so i have added in drop box , plz check it , or any other method you need to upload the file.
https://www.dropbox.com/s/3vkd5xrsck...20-%20Copy.zip

[June7]

You posted an MDB. MDB does not have Attachment field type. Image control in MDB does not have a ControlSource property. Dynamically displaying images in an MDB requires code. Review http://support.microsoft.com/kb/285820

The Image field is not an Attachment type, it is an OLEObject type. I've never had good experience with the OLEObject field.

EDIT: The ControlSource property is available when viewing the MDB in Access 2007 or later.