Re: [MS_AccessPros] Please help with VBA code

 

Hello Crystal and happy New Year. You did have helped me before on several occasions and I am grateful

I need two controls for SKU on this form. One will contain the SKU provided by vendors and manufacturers and cannot be edited because then their system would not recognize it on purchase orders. Second will have the same SKU plus ".jpg" in order to import the related image from independent file for receiving form. I have the following codes.

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

On Second Field I just named it Map

Private Sub Map_GotFocus()

Map = [fullname] & ".jpg"

End Sub

 

Problem is when I fill a new record on the form and get  to second field no image is present but if I go back to previous record and then back to new record image is there. Please help

Thankful - Ken

__._,_.___

---

Posted by: kenaf42@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (9)

---

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

.

__,_._,___