Re: [MS_AccessPros] Please help with VBA code

 

I'm not sure I totally agree with how you have this set up but you can try call the form's current event in the Map GotFocus

Private Sub Map_GotFocus()

Map = [fullname] & ".jpg"

Form_Current

End Sub

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of kenaf42@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, January 3, 2019 2:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Please help with VBA code

 

Duane, on first field I have only SKU provided by vendors and manufacturers and cannot be edited because then their system would not recognize it on purchase orders. On second field (Map) I have the code you helped me with:

Private Sub Map_GotFocus()

Map = [fullname] & ".jpg"

End Sub

 

And on form Current Event:

Private Sub Form_Current()

If IsNull(Me.[Map]) Then

    Me.Image10.Visible = False

    Else

    Me.Image10.Picture = "C:\Images\" & [Map]

    Me.Image10.Visible = True

End If

End Sub

As I said it works but no image is imported while new record is filled but if I go to previous  record and back to present record image is there.

 

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (11)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1
• New Photos 1

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___