ACCESS FEED: [MS_AccessPros] Re: open form based on combo box selection

Senin, 26 Maret 2012

[MS_AccessPros] Re: open form based on combo box selection

Duane -

Thanks for the assistance! I've got the forms opening now based on the selection I've made. However, when I'm running a report, the report opens but instead of seeing the name of the Vendor the ID number is displayed. I've looked at this all morning and still can't seem to find what I'm doing wrong. I've uploaded my database to the AssistantNeeded folder its under Capital Project Invoice Log.

Your help is greatly appreciated!!

Thanks!

Katrina

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> Your form record source [Capital Project Invoice Log 2012] doesn't have the field [Vendor Name] so it is asking for it.
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@> wrote:
> >
> > I've tried a few more things but still getting the same parameter box. Can anyone help please.
> >
> > Thanks!
> >
> > Katrina
> >
> > --- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@> wrote:
> > >
> > > I'm not exactly sure what you want me to try? I'm not an expert at access, so I'll need more instruction. I looked at the file you put in the assistance needed file, but don't know which part you want me to look at.
> > >
> > > Thanks!
> > >
> > > Katrina
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, eldigul <no_reply@> wrote:
> > > >
> > > > try this... (temp.rar, in the assistanceneeded folder).
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@> wrote:
> > > > >
> > > > > I have a database that has a form "Find Invoice" and this form has a combo box "vendor id" and a command button that has a macro to open up the "New Invoice" form based on the selection made. When I select a vendor and click "go" instead of opening the form with the information it opens a parameter box that asks me to enter the vendor name. How can I avoid that parameter box and have the form open automatically? I have uploaded my capital project invoice log in the assistance needed folder.
> > > > >
> > > > > Any help is appreciated!
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Katrina
> > > > >
> > > >
> > >
> >
>