Day of the month not required to be visible

[scubadiver007]

Hello,
I have a table that records a list of dates using the first of the month in short date format (01/01/2011) and I have the following query

SELECT Format([dateworked],"mmm yyyy") AS Monthyear, Table_dateworked.dateworked
FROM Table_dateworked;

This query is the source for a combo box so it stores the actual date but the formatted date is visible.

An additional complication (if it has to be) is that I have two combo boxes and I want to make sure the finish date is later than the start date, so I have a similar query which only returns later dates than the start date.

What I would like to do instead is to remove the combo box and to get the user to type in the month and the year in the "MMM YYYY" format, default the day to the first of the month and make it invisible.

How difficult would this be? Would it be easier to enter the date in short format and change the format using the after update event?

Any ideas?

 

[namliam]

why have a user manually enter data that you can force him to pick automated?

Always prevent any manual input when possible, to eliminate typo's and the sort.

 

[scubadiver007]

The specific records are for recording work history (company, job title, start date and end date).

I had originally thought that recording the three most recent job positions would be enough (going back to the beginning of 2011) but that is arbitrary. It depends how long they were in the job for and that potentially mean going back thirty years.

Maybe staying with the combo box is a better option and for the reason of eliminating errors as you say.

 

[namliam]

It isnt hard to make a list of months for 30 years or more,

For Y = 1950 to 2050
    for M = 1 to 12 
          debug.print dateserial(Y,M,1)
    next M
Next Y

Alternatively split the year and month up, makes for a (much) shorter list