concatenate dates

[Craftsman61]

What I am trying to do is to have three comboboxes each respectively based on individual tables (day, month, year) and have the user select a day, select a month and select a year and concatenate(i think) the selections as a date and placed in a textbox for another tables field called date.

I have the three comboboxes designed and working what i tried in the text box is this

=[cboDay]& "/" & [cboMonth] & "/" & [cboYear]

what the textbox gives me is #name?

Any assistance is appreciated

 

[mikey69]

I suspect that your problem is that you need to concatenate as follows:
=Me!cboDay & "/" & Me!cboMonth & "/" & Me!cboyear

search the help file for more info on the Me operator.

 

[Craftsman61]

Sorry but that did not work. (if it helps any all three variables to concatentate/join whatever, are numbers (the day is 1-31, the month 1-12, the year 2000-2010).
I need to combine them to make a date to go into a date field.

I am currently trying to work out in vb code something but am still having no luck....

 

[Craftsman61]

WHELP, I closed my db and did some other work then came back to my db and retried my original process and it worked.

I have no ideas as to why it didn't work before and now it does..anyway thanks.