Continous form, not updating properly?

[g4tv4life]

Hey everyone, I have a inventory program with pictures but I have a small bug I can't solve


First off, its a continous form where by double clicking it runs this code:

Private Sub Image41_DblClick(Cancel As Integer)
 If Me.Command52.Visible = False Then
  Me.Box55.Visible = True
 Me.Command52.Visible = True
Me.Command53.Visible = True
 Me.Command54.Visible = True
  Me.Combo50.Visible = True
    Me.Combo50.Value = ""
  Me.Combo50.Value = Me.Category.Value
 End If
End Sub

This Code, reveals a little form for selecting a photo, The problem is the bolded line.
I'm trying to autofil a combo box from a combo box on the record. Problem is, its always
One behind (I.E. Double click one that the combo says PPE it works fine (for the first time, do another record with COMMUNICATIONS as it, it stays PPE until I double click it again, then it updates.)

I've tried both Me.Category.Value and Me.Combo70.Value both do the same thing.

Any Idea's

[June7]

Why does this value need to be duplicated?

Want to provide db for analysis? Follow instructions at bottom of my post.

[g4tv4life]

Its more of a convenience thing, I use that value to create the stored path for the image, by having that code working the person (mainly me) doesn't have to change the combo box every time when attaching a new image.

[g4tv4life]

Solved it, The clicking of the image didn't set the record as the current one, so it was using the 1st record's value. Solved by putting a transparent button over the image, which moved the focus to the current record.

[June7]

Not sure what you mean by 'change the combo box every time'. What is selected by combobox? What do you mean by 'attaching new image'? Are you embedding images in attachment field or just saving path to external image?