Don't see it

I

iami

Access 2007, XP pro

Having a Calendar issue, can't figure out. I would certianly
appreciate any help or direction.

Here the case:
StartDate, format dd-mmm, has Popcalendar() , works fine
NumbSession format Text. usally numbers 1 thru 10
EndDate format dd-mmm has a popCalendar also, but
I want EndDate to be the same as StartDate "if" NumbSession =1, else
I want to use popcalendar to select the EndDate.

If have this in Control Source opf EndDate:
=iif([NumbSession]=1,[StartDate],[EndDate])
where EndDate should be blank and could be replaced with popCalendar
date, It don't work.....
I have tried " " and 'nothing', and null. These two clear StartDate
when StartDate not= "1", but prevent popcal from inserting a date on
click.

Any ideas ?

Tom Rector
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Woes 5
Clear Bound Control 1
Display billing month based on start date and end date 5
Make a table from 2 text field on a form 3
Passing a Date Variable from Code to Update Query in a Loop 7
Storing and Retrieving 'DateLastStored' 6
Distribute Cost by Month 0
Querying between two dates doesn't work if Start and End are ident 10

Top