Search results

The field names are the same as the control source names. I know this is something so simple that I am just missing. I have even gone so far as trying "= [Form]![form name].[control source] & field2 & field3" which results in my field 4 (Document ID text field) = #Name?. I know you said you...

Thank you for your response. I was referring to the field names. You mention creating an unbound form. This is a bound form. The first combo box (Department) has a row source = "SELECT [GL Codes Contacts].ID, [GL Codes Contacts].GLCode, [GL Codes Contacts].Department FROM [GL Codes...

I have a field on a form that I would like to auto populate with the (concatenated) contents of 3 other fields on the same form. The first 2 fields are drop down boxes and the 3rd is a hand keyed text field. For example, the first field is Department (4 digit number from drop down box) Second...