Field order in subform datasheet view

[David]

Using Access 2002, I have a subform that uses a query to get its
fields. Each field has a data entry component on the form. The form
is in Datasheet view. I added two new fields, changed their tab order
to the position I wanted, placed them in the query in the place that I
wanted, and moved the data entry components to the place I wanted, but
they still show up as the last two fields in the datasheet view.

What am I doing wrong?

Thanks,

David

 

[pietlinden]

Sounds really stupid, I'm sure, but change their position in the table
if you need to rearrange a datasheet. That's where it gets the field
order from.

 

[Guest]

Click on the field name (gray) to select the whole field, then move it to any
where you want. Sorry for my English, but I hope you understand what I say.
Good luck.

 

[RoyVidar]

Using Access 2002, I have a subform that uses a query to get its
fields. Each field has a data entry component on the form. The form
is in Datasheet view. I added two new fields, changed their tab
order to the position I wanted, placed them in the query in the place
that I wanted, and moved the data entry components to the place I
wanted, but they still show up as the last two fields in the
datasheet view.

What am I doing wrong?

Thanks,

David

Did you try a drag'n'drop with the column headers when the form is in
datasheet wiev?

 

[David]

Thanks for the responses. I took RoyVidar's advice and it worked
perfectly.

Thanks again!