Problem with this form

[snagrat]

In the attachment is a form.

What I want to happen is when the product is double clicked from the list box I wish for the details to show in the text boxes below.

I have it working but if you then double click another product and a few more you will find that some information of the product (description) changes. I don't want it to change.

I have tried setting the form so no edits are allowed but this does not work.

Can anyone help

 

[KevinM]

See modified db attached

Created a new query including prods and tiles.

Based form on this query.

Made list box unbound

Used OnClick even on list box to find first tile record in form.

Note: single click is more intuitive than double click in this case.

Macro not needed.

 

[snagrat]

That works beautifully.

Thanks for that.