Hi Mitch, I tried the following: Forms!viewincidentsbymonth!Imy.RowSourceType = "Table/Query" Forms!viewincidentsbymonth!Imy.RowSource = "empbymonth"
'where Imy=Listboxname It still asks for parameter field data. I know, I'm not getting something.... PS. I'm not that good with VB. Thanks Joe --- In [email protected], "J. Mitchell Grossack" <[EMAIL PROTECTED]> wrote: > > Set the listbox rowsource after the user chooses the month and year. > If the rowsource is set on form open that is when it is looking for > the parameters, not when you set the visible property. > > Hope this helps, > Mitch > > --- In [email protected], "eliotchs" <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm trying to base a listbox on two combobox choices. > > Example: > > form has two comboboxes month and year. > > and a listbox, set to visible.false on open > > Once month & year is chosen,(OnExit) > > I make the listbox visble, but I still get > > the parameter boxes asking for the Month and the year. > > > > Unlimate goal is: User chooses a month, then chooses a year, > > the listbox then becomes visible on the same form with the clients > > based on chosen month and year. > > > > > > Is there a way around this? > > > > > > Thanks In Advance > > Joe > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
