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

Selasa, 24 Maret 2015

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

have u tried to use subform linked with some sort of unique id or something as a primary key..?? It works all the time with me..

Sent from Yahoo Mail on Android

From:"bubbleblue_007@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Date:Tue, Mar 24, 2015 at 1:19 PM
Subject:[MS_AccessPros] VBA code to call specific record in a form

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: mac ba <macba2000id@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•