Form with ListBox on LHS, a subform in datasheet view in the middle and 3 cmdBtns on RHS.

User has imported an Excel table, visible in subform datasheet, with no headers. ‘Headers’ or FieldNames attached by Access are F1, F2……etc. and are visible as column ‘headers’ in subform datasheet.

User must now select a ‘standard header’ from the list box on the LHS, click a ‘Header’ in the datasheet e.g. F2 and click 1 of 3 cmdBtns either to attach the new header, remove a mistake or delete a column from the subform.

Please can anyone help in writing the VBA to the cmdBtn click events?

Regards

Phil

Can you explain what you need?

mmcdonal