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

John -

Did you get a chance to look at the database? Still can't figure out what I'm doing wrong... Please help! I've got a deadline and am in a bind.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@...> wrote:
>
> John -
>
> I changed the combo boxes on the search form to the match the ones on my contract form, and I took off the quotes; however, it's still not pulling up the information. I've uploaded an updated database showing what I did. Also, now everytime I make a selection and hit the command button to pull of the information it creates a new record in my contract table, not sure why it's doing that now.
>
> Thanks!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > Well, you have a Vendor ID on the Contract Form, so you need to change your
> > filter rather than add the Vendor Information table. The combo box on your
> > search form should be exactly the same as the Vendor combo box on the Contract
> > Form. That will bind the search combo to the ID, not the vendor name, and you
> > can search using that. Don't put quotes around the parameter value because
> > you'll be searching on a number, not a text value. You need to do a similar
> > thing to your Employee search - search for the matching ID, not the name. Your
> > search on "Category" (Type of Lease) should work because you're using the text,
> > not an artificial ID.
> >
> > 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: Tuesday, May 31, 2011 8:13 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Open form using combo box and command button
> >
> > John,
> >
> > I uploaded a new database that shows the arguments in the Find Contract Form.
> > I'm not sure how to add the vendor name into the record source of the contract
> > form. At this point I feel if I add anything I'll mess up my database.....
> >
> > Thanks!
> >
> > Kat
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Kat-
> > >
> > > I found no argument in the macro to open the contract form. What is in the
> > > Where Condition? Note that Vendor Name isn't in the Record Source of the
> > > contract form, so perhaps that's why you're getting prompted.
> > >
> > > 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: Tuesday, May 31, 2011 6:23 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > >
> > > John,
> > >
> > > I do have an argument in the Where Condition; however, when I make a selection
> > > and click on the command button it pops up another small window asking me to
> > > type either the vendor name or employee name, depending on which command
> > button
> > > I'm using, instead of immediately taking me to the contract form and pulling
> > up
> > > the information i've requested. I'm not sure what's wrong with my argument.
> > >
> > > Thanks!
> > >
> > > Kat
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > > >
> > > > Kat-
> > > >
> > > > You need to add an argument in the Where Condition of the OpenForm action in
> > > > your macro. Depending on what you're filtering, it needs to look something
> > > like
> > > > the filter in the Embedded Macro in the Find Vendor form.
> > > >
> > > > 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: Tuesday, May 31, 2011 5:39 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > > >
> > > > John,
> > > >
> > > > Yes, I saw that, but what it should do is when you make a selection and
> > click
> > > on
> > > > the control button it should open up that record in the contract form, but
> > > it's
> > > > not working. I'm not sure what I'm doing wrong, and the reason for the
> > error
> > > on
> > > > the dates is because I didn't put in a contract end date. How do I get the
> > > > control button to work so that when I make a selection it opens up that
> > > record?
> > > >
> > > > Thanks!
> > > >
> > > > Kat
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > wrote:
> > > > >
> > > > > Kat-
> > > > >
> > > > > The Find Contract form doesn't apply *any* filter in either the Find
> > > Contract
> > > > or
> > > > > Employee Find macros. If I try to use one of your search buttons, I get
> > an
> > > > > error in the Current event of Contract Form trying to subtract today's
> > date
> > > > from
> > > > > a contract that has no date.
> > > > >
> > > > > 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: Tuesday, May 31, 2011 4:17 PM
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > > > >
> > > > > John -
> > > > >
> > > > > It's the Find Contract Form I'm having problems with. Each time I select
> > a
> > > > > contract or employee name to find a contract it prompts me for either the
> > > > vendor
> > > > > name. I have uploaded the database I'm currently using that has a few of
> > my
> > > > > contracts already put in.
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Kat
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > > wrote:
> > > > > >
> > > > > > Kat-
> > > > > >
> > > > > > I get no prompt at all when I use your Find Vendor form - after I
> > entered
> > > at
> > > > > > least one row in Vendor Information.
> > > > > >
> > > > > > 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: Tuesday, May 31, 2011 3:38 PM
> > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > Subject: 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
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>