You are using lookup fields in your table which many of us veterans consider horrible practice. You might want to read about the evils of lookup fields at http://access.mvps.org/access/lookupfields.htm.
If you want the Vendor Name in the report, add [VENDOR INFORMATION] table to your report's record source so you can include the actual vendor name rather than your Vendor ID.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@...> wrote:
>
> 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
> > > > > >
> > > > >
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar