[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Pictures not following ComboBox

Posted on 2011-04-18
Medium Priority
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
        Me!DisplayPicture.Picture = GetPathPart & Me!txtPicture
    End If

        Me!CboStaffName = "StaffID"
End Sub

Open in new window

Question by:poucedeleon
  • 5
  • 2
LVL 26

Expert Comment

ID: 35421923
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?
LVL 26

Expert Comment

ID: 35421962

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
LVL 26

Expert Comment

ID: 35421975
Altered sample (opened with Access 2010--references may be broken for prior versions)
Let me know
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 35422077
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.
LVL 26

Accepted Solution

Nick67 earned 1000 total points
ID: 35425635
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


Author Comment

ID: 35428576
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.
LVL 26

Expert Comment

ID: 35428598
No Problem.

Hope you can puzzle out what's going BANG!

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question