Pictures not following ComboBox

I added pictures to my read-only "View" Form and when it is opened it show the picture of the employee, but on the "Entry" form you can select an employee with a combo box but the picture does not change to match the selection. I've added code to the frmEmergencyContactsEntry afterUpdate to requery but no luck. I'm hoping someone can point me in the right direction. Post-Copy-Employee-Information-A.zip
Private Sub Form_AfterUpdate()
If IsNull(Me!txtPicture) Or Me!txtPicture = "" Then
        ' do nothing
    Else
        Me!DisplayPicture.Picture = GetPathPart & Me!txtPicture
    End If

        Me!CboStaffName = "StaffID"
        Me!CboStaffName.Requery
                   
End Sub

Open in new window

poucedeleonAsked:
Who is Participating?
 
Nick67Connect With a Mentor Commented:
It does on my home Access 2010 machine
It does on my work Access 2003 machine.
db on the desktop
Your picture folder dragged to the root of C:\
It plays.
Proof below

one.jpg
two.jpg
0
 
Nick67Commented:
read-only "View" Form?
the "Entry" form?

Just which one is which?
And since you posted it secured, just how am I supposed to examine it?
0
 
Nick67Commented:
Alright.

I held the shift button and got in.
You got a little mixed up with your navigation buttons.
On the form with the combo box to select, the main form has nav buttons, and the pictures work.

The other form, the SUBFORM has the nav buttons, not the main form.
There is no way to move it to new records, so the picture doesn't change.

Make the nav buttons the same (on main form) and they work correctly
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Nick67Commented:
Altered sample (opened with Access 2010--references may be broken for prior versions)
Let me know
Post-Copy-Employee-Information-A.mdb
0
 
poucedeleonAuthor Commented:
When you open he db and click on Emergency Contacts, a Entry Form Opens. The last record in the db is displayed with the pic. But if you change record, (Select a diferent employee from the combobox at the top or the record selector at the bottom) the picture does not update.
0
 
poucedeleonAuthor Commented:
Nick67
I brought the db home and tried it on my home computer and it works great. All the hours spent working on this. There must be a issue with my computer at work. Thanks for taking the time to look at it.
0
 
Nick67Commented:
No Problem.

Hope you can puzzle out what's going BANG!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.