Yes, John, I think it IS time for me to learn basic coding and I will check out your website and download a database to get me started [again]. Thanks so much, John, you're great! Doreen
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Doreen- > > That should work just fine for fields that cannot be Null. If you need to > filter on a field that might not have a value, you need to use this on the > criteria line: > > [Forms]![ReportForm].[RepID] Or ([Forms]![ReportForm].[RepID] IS NULL) > > But don't you think it's time you learned how to basic coding? You can find > examples of custom "filter by form" on my website in the databases in the > Downloads area. > > 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 10:14 AM > To: [email protected] > Subject: [ms_access] Re: Multi-option form for reports > > 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 > 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/
