Hi Mohammed,

Borislav didn't tell you, you should substitute something for " TYPE_OF_THE_FIELD (LENGTH_OF_THE_FIELD) ", because it's quite obvious.

You only have the field name of the field you want within textbox1.value etc, right? Either you have another textbox for each field, to which you enter the needed field type, or you use afields(), display that info in a multicolumn listbox and let the user select the fields wanted. copy the selected fields into a new array, add your three always needed fields and then CREATE TABLE FROM ARRAY ....

Too little time to tell you all the datails how to set up the listbox to display the AFields() array etc, sorry.

Bye, Olaf.