Ending date

[cmw]

If I select month&year,I want month enddate. eg. Jaunuary-2008, Result is 31/12/2008. How will do it?
Combobox value how do assign in form_load? me.combo="CASH" or me.combo.text="CASH" or me.combo.value="CASH" Error display for above three method assign.

 

[missinglinq]

How are you populating the month and year? Is the user manually filling it in? Will the month/year always have a hyphen between them? Is this a date field or text field? And finally, do you really mean if you select Jaunuary-2008, you want your endmonth results to be December 31, 2008. What results would you want if you select February-2008? Are you looking for the end of the given year?

What error is displaying with you combobox assignment code? Is combo the actual name of your combobox? If it is, Me.Combo = "CASH" and Me.Combo.Value = "CASH", as well as Combo = "CASH" and Combo.Value = "CASH" should work, assuming you actually have "CASH" as an item in the combobox.

 

[cmw]

I am really sorry. Textbox value is January-2008, I want Result is 31/01/2008. Also February-2008->29/02/2008 unless 28/02/2008.
if me.combo.text="CASH", Display Error:"You can't reference a property or method for a control unless the control have the focus".
me.combo.defaultvalue="CASH" or me.combo="CASH" -> No Error,but value don't assign.