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

 

Afiqah-

What is the name of the form containing the cboModel combo box?  If it's not frmHome, then you need to change what's in your Where Condition.  Also, you need to open frmModelSpecification before you close the form containing the combo box.

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 27, 2015, at 3:14 AM, bubbleblue_007@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

After user selecting a model from cboModel combo box, then user click command button that I named it search, it closed the frmHome form and a dialog box named enter parameter value pops up. In the enter parameter value dialog box, Forms!frmHome!FordFiesta appears and a blank box invoke the user to type model name based on model name records in tblModelSpecification. If the program found the model name, it will open frmModelSpecification and show records of the selected model name.

Record source of frmModelSpecification is tblModelSpecification

How can I skip the enter parameter value dialog box? The user need to spell the model name correctly and exactly the same as what in the tblModelSpecification to open the correct record in frmModelSpecification. So there is possibility that some user did not get the correct record or results.

Thanks John!

Best 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 (13)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___