Access 2000 VBA Question Hyperlinks

[MAB]

Hi,

Could someone please tell me how I can automatically have a hyperlink field populate with an address. I used the following code

Me!Photo = "C:\Photos\P0" & myid & ".jpg"

Me!Headshot is a hyperlink field displaying in a form. After another field is updated I want this field to populate automatically. The above line only seems to populate the text to display but not the hyperlink address.

Thank you.

[MAB]

I think I figured it out. I need to insert # in the code below

Me!Photo = "#C:\Photos\P0" & myid & ".jpg#"

Once I added the pound sign it seemed to work.