Access 2010- How do I ...

Question

I've been looking at some of the templates in Access 2010 and I noticed that there are some places where the record ID is in blue, underlined, and can be clicked on to open other forms.

I was wondering how to set this up.

Does anyone have any suggestions or a referral to a web site with instructions on how to do this?

Thanks,

---

Steven Schuyler Berkeley, California USA

Answer 1

Open the form in design view, bring up the properties dialog, goto the Event tab and finally click on the ... button at the end of the On Click event.  This will bring up the Macro editor and from there you can clearly see what makes it all work.

---

Daniel Pineault, 2010 Microsoft MVP
http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Hi Steven,

Welcome to the MSDN forum!

In other than Daniel's suggestion, the related method for opening other forms can be DoCmd.OpenForm. Please check this link: http://msdn.microsoft.com/en-us/library/ff820845.aspx

Thanks. 

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us