I have created several data forms using the VB Data Form
Wizard for my app. In the wizard, I set the form layout to
single, set my record source to a table in the db and
assign all available fields in the table. The Column to sort
by selection is set to None. However, when I run
my app and review my data in the data form, the first record in the
form is not the same record as when I am viewing the data in Access.
It appears that the data is being sorted in accordance with one of the
fields. How can I programmatically force VB to display the data
identically as it would appear when viewing in Access (ie., no sort!)?

Thanks in advance for the help

Steve

I have created several data forms using the "VB Data Form Wizard" for
my app. In the wizard, I set the form layout to "single", set my
record source and assign all available fields. The "Column to sort by"
selection is set to "None". However, when I run my app and review my
data in the data form, the first record in the form is not the same
record as when I am viewing row 1 in Access. It appears that the data
is being sorted in accordance with one of the fields. How can I
programmatically force VB to display the data identically as it would
appear when viewing in Access (ie., no sort!)?

Thanks in advance for the help

Steve