DatePart in Filter By Form field

Danny

Guest

Posts: n/a

4th May 2010

Howdy.

I've got a form based on a query, with a column in that query using the
DatePart function. Here's that field definition:

WeekDay: DatePart("w",[tourdate])

In the query, the values are correctly returned (1-7).

In the form, those values display correctly.

When I apply "Filter By Form", the pulldown for this field doesn't show
items 1-7, but shows a list of actual dates - 3/24/2010, for instance.

What's going on?

« stLinkCriteria Syntax | allow user to highlight field on form »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter 2nd form based on field value of 1st form	Yara	Microsoft Access Forms	4	14th Jan 2010 06:55 PM
Filter 2nd form based on a field value of 1st form	Yara	Microsoft Access Forms	0	11th Jan 2010 06:30 PM
filter combobox in sub form by field in main form	=?Utf-8?B?ZGVi?=	Microsoft Access	5	8th Nov 2007 04:17 PM
filter by form field	=?Utf-8?B?bWlzczAzMQ==?=	Microsoft Access Reports	5	27th Nov 2006 05:39 AM
Getting DatePart from a Date field into a combo	Emma	Microsoft Access Form Coding	2	14th Apr 2004 08:26 AM