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

Selasa, 31 Mei 2011

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

Good Morning John,

This is the SQL of the Record Source.....

SELECT [VENDOR INFORMATION].[VENDOR NAME]
FROM [VENDOR INFORMATION]
ORDER BY [VENDOR INFORMATION].[VENDOR NAME];

I have also uploaded a zipped file of my database under Kats Files if you want to look at it.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>