Re: [MS_AccessPros] VBA code to call specific record in a form

 

Afiqah-

Label controls don't have any events, so I don't see how you're going to make this work.  Why not use Command Buttons and the Click event?  In the respective events, use DoCmd.OpenForm with a filter specified in the WhereCondition parameter to display the record.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 24, 2015, at 2:34 AM, bubbleblue_007@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi,

I'm using Ms Access 2007.

Currently, I have designed a form (frmHome) consist of  10 labels which I named it lblFordFiesta, lblFordFocus, and etc.

I would like the user to open another form named frmmodelspecification that display Ford Fiesta record (display all fields) when the user click on lblFordFiesta and display Ford Focus record (display all fields) when the user click on lblFordFocus.

Ford Fiesta and Ford Focus records are stored in tblmodelspecification and consist of 37 fields. frmmodelspecification is created based on tblmodelspecification table while frmHome is created and categorized as unrelated objects.

Hope you can guide me to write VBA code for this event.

Thanks in advance!

Regards,

Afiqah

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___