By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

default value is current month name

P: 51
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
May 18 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,365
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.
May 18 '07 #2

JConsulting
Expert 100+
P: 603
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
Expand|Select|Wrap|Line Numbers
  1. SELECT tblMonth.MonthNo, tblMonth.MonthDescription
  2. FROM tblMonth where tblMonth.MonthNo = Month(date())
  3. ORDER BY tblMonth.MonthNo;
  4.  
May 18 '07 #3

P: 51
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.
May 18 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.