We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Pictures not following ComboBox

Kevin
Kevin asked
on
Medium Priority
378 Views
Last Modified: 2012-05-11
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

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
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?
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
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
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
Altered sample (opened with Access 2010--references may be broken for prior versions)
Let me know
Post-Copy-Employee-Information-A.mdb
KevinCaptain

Author

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.
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
KevinCaptain

Author

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.
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
No Problem.

Hope you can puzzle out what's going BANG!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.