[RESOLVED] combining fields

I have to confess.. I am getting lazy using this forum. I haven't done the necessary search for a solution to this problem.. but I really hope that some one can give me a quick solution Thanks

I have two fields in my form. One is the month field and another is a combo box for a year field. But my underlying table has only a single field called ReportMonth which has data stored in the format "August, 2005"

I want to combine the user input from my two fields so as to write on the table above in the required format. Is there an easy way to use. So far I have been using the controlsource property in my fields without going into VBA. So I will appreciate a solution without using recordset. Thanks

Quote:

---

Originally Posted by rochak

I have to confess.. I am getting lazy using this forum. I haven't done the necessary search for a solution to this problem.. but I really hope that some one can give me a quick solution Thanks

I have two fields in my form. One is the month field and another is a combo box for a year field. But my underlying table has only a single field called ReportMonth which has data stored in the format "August, 2005"

I want to combine the user input from my two fields so as to write on the table above in the required format. Is there an easy way to use. So far I have been using the controlsource property in my fields without going into VBA. So I will appreciate a solution without using recordset. Thanks

---

Try this:

VB Code:

Private Sub Command1_Click()
    MsgBox Me.Text0 & ", " & Me.Combo2
End Sub

Thanks's mark, It works.