default value is current month name

[rockdc1981]

i want my combo box to show the current month when i add new data...the combo query goes like this

SELECT tblMonth.MonthNo, tblMonth.MonthDescription
FROM tblMonth
ORDER BY tblMonth.MonthNo;

month no=month description
1 january......... and so on

is this possible...or any suggestions..thanks

[Rabbit]

i want my combo box to show the current month when i add new data...the combo query goes like this

SELECT tblMonth.MonthNo, tblMonth.MonthDescription
FROM tblMonth
ORDER BY tblMonth.MonthNo;

month no=month description
1 january......... and so on

is this possible...or any suggestions..thanks

There's a default value option for most controls.

[JConsulting]

i want my combo box to show the current month when i add new data...the combo query goes like this

SELECT tblMonth.MonthNo, tblMonth.MonthDescription
FROM tblMonth
ORDER BY tblMonth.MonthNo;

month no=month description
1 january......... and so on

is this possible...or any suggestions..thanks

SELECT tblMonth.MonthNo, tblMonth.MonthDescription
FROM tblMonth where tblMonth.MonthNo = Month(date())
ORDER BY tblMonth.MonthNo;
 

[rockdc1981]

Credit goes to all who replied on my post.

For the purpose of resolving my issue and reference to others who might use this



SELECT tblMonth.MonthNo, tblMonth.MonthDescription
FROM tblMonth
WHERE (((tblMonth.MonthNo)=Format(Now(),"mm")))
ORDER BY tblMonth.MonthNo;


then set default value to Format(Now(),"mm")))

Thanks for the help guys.