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/
