I have an access database where in i have 3 separate fields for day, month and year which are comboboxes. I have an separate field where i need to combine these 3 fields into that single field(dd/mm/yyyy). can somebody help me on this please.
Dim xYear As Integer, xMonth As Integer, xDay As Integer, xResult as String
xYear = rs!year ''Change rs to your record selector name...
xMonth = rs!month ''Also change the field names year, month, day to your field names...
xDay = rs!day
xResult = xDay & "/" & xMonth & "/" & xYear