ACCESS FEED: RE: [MS_AccessPros] Open form using combo box and command button

Jumat, 27 Mei 2011

RE: [MS_AccessPros] Open form using combo box and command button

Kat-

What is the SQL of the Record Source of the form you're trying to open?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
Sent: Friday, May 27, 2011 10:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Open form using combo box and command button

Hello all!

I have a search form with several combo boxes and command buttons. When I click
on the combo box and select a name I want to then click on the command button
which will open up my form based on the selection made in my combo box.
Currently, what is happening after I select a name in the combo box and hit the
button is another box pops up asking me to enter the vendor name again. How do
I get rid of that and have the command button take me directly to that form to
bring up the information selected for the vendor? Any help is appreciated it!

Thanks!

Kat

------------------------------------

Yahoo! Groups Links