Record Data does not change per record

[JHG]

I have the problem that the record info does not save per record.

The only info which are saving is the quantities, Stock No and Stock Name. All the other fields are Combo Boxes where specific variable data must be selected and it may differ per record.

The image should also change per record, but it keeps the image throughout all the records.

I am new at access.

[June7]

Would need to examine database. If you want to provide for analysis, follow instructions at bottom of my post.

[GinaWhipp]

Are those combo boxes BOUND to the field in the table? In other words, do they have a Control Source? What makes the images change? Is there code that does that?

[JHG]

No they do not have a control source. Should it have that?

[JHG]

I only have winrar. Will it work for you? If not, I can download perhaps what will work for you.

[JHG]

Nope. I noticed in design view the boxes show unbound.

[GinaWhipp]

Well, being UNBOUND they will not save back to the Table. They need to be BOUND to the field in the Table.

[June7]

Use Windows Compression to zip files for attaching to post.

[JHG]

I hope it is ok

[JHG]

I will try to do this in the property panel I suppose

[June7]

I would not use OLEObject field. Review this discussion https://www.accessforums.net/showthread.php?t=77669

You have an Image control on form but that will not work with OLEObject field. Attachment field works with Image control.

Also review https://www.accessforums.net/showthread.php?t=73766

Regarding inventory control, review http://allenbrowne.com/AppInventory.html

If you want combobox selections saved, then bind to fields.

[JHG]

The binding works except for the images

[GinaWhipp]

True but you can use the Image Control to display an image from a stored path.

[June7]

Did you read post 11 and review the referenced links?

[JHG]

Yes, It is working perfectly now Thank You very much