Kamis, 26 Maret 2015

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

 

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: bubbleblue_007@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

.

__,_._,___

Tidak ada komentar:

Posting Komentar