Unsure how to add a picture or icon that will load a pop-up notes windows when clicked

[Tall_Paul]

I'm pretty new to Access, so this may seem like an easy answer for many but here is the situation:



I have a table called Scott's Music Which contains all of the information in the database. There is a field in this table called Notes of the memo data type. I have created a form called SMForm which displays most of the information from the table. Because of the compact nature of the form I have no room to add a textbox to display the text in the Notes field. So I thought it would be useful if I could simply add a small picture or icon that, when clicked. would popup a small window to view or edit the notes. Additionally, I wanted the picture or icon to be redmemo.jpg if there wasn't already existing notes in the Notes field and greenmemo.jpg if there were existing notes for that record.

I'm sure this can be done, but since I only have rudimentary knowledge of VBA coding or macros I would really appreciate the guidance of a more knowledgeable user.

Thank you.

-Paul

[isladogs]

Add the Notes field as a small hidden control.
Create a separate popup form to display the Notes.

On the main form, add this to the form current event

if Me.Notes<>"" Then
.  Me.mybuttonName.Picture= ..... enter full path to greenmemo.jpg here
Else
 ...similar code for redmemo.jpg
End if

The button itself click code would open your popup form.

However a better method is to enable / Disable the button

if me.notes<>"" then
. Me.buttonnwme.enabled=true 
Else
. Me.buttonname.enabled=false
End If

[Gicu]

Hi there,


Have you considered using a text box to show if you have notes, you can then use conditional formatting to show Yes in red and No in green. I am also attaching a sample db I did awhile ago to show you how to use a pop-up editor form (hint : I use the double-click event of the text box to open the pop-up for that field).


Cheers,
Vlad