Rearrange column order in search form (opening as acFormDS)

[StanPrice]

I'm opening a search form using DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria for user filtering purposes. I added a column which it now appears as the last column - I need it to be the 4th WHEN THE FORM OPENS. I can move after it opens, but it won't default there. Tried rebuilding the query and the form, but it still opens with this column at end of form - how can it be placed where I want it?

[burrina]

I'm assuming this is a combo box using a query for it's record source. Just move the field you want to be in the 4th column to the appropriate number in your query. Remembering that the first field counts as 0.

HTH

[hapm]

AFAIK the order of the colums in datasheet view is defined by the activation order of the controls in the form. Simply open the activation order list for controls in design view and move your control to the place you want it to have. If that doesn't work, move it in DS view, resize the column a bit and hit the save button while still in DS view and reopen to see if that worked.