John, My problem is that I don't know "code"...I actually have figured out a way to do it within a query that has IIF statements as the criteria for each field, such as: IIf(IsNull([Forms]![ReportForm].[RepID]),[DataEntry].[RepID],[Forms]! [ReportForm].[RepID]) So far it seems to work unless you can help me write some code.
Thanks for your help! Doreen --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Doreen- > > The give the user maximum flexibility, you should use reports with > unfiltered recordsets and dynamically build the "WHERE" clause in code > behind the form. Use the filter you build in code in the WhereCondition > parameter of the OpenReport method. Examine each option and include a > filter for it only if the user has picked or entered a value. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of rokkeee > Sent: Thursday, January 12, 2006 9:41 AM > To: [email protected] > Subject: [ms_access] Multi-option form for reports > > Within my database, I know the different options we'll want to use for > reporting. I've created an unbound form with several "options" fields > (combo boxes) and have each field linked to an individual query right > now. But, how can I set up the 'reality' that we will choose more than > one option at a time? For example, we would choose a RepID and a > Product at the same time. > > Thanks, > Doreen > > > > > > > Yahoo! Groups Links > 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/
