| | |
|
|
|
Table Order in Access Form |
|---|
| message from =?Utf-8?B?WmFjayBNYXlv?= on 17 May 2004 |
Thanks
|
| tina replied to =?Utf-8?B?WmFjayBNYXlv?= on 17 May 2004 |
if you're using the table as the direct RowSource of the combo box
(dropdown) on the form, you need to use a query or SQL statement instead,
and set the sort order in that.
hth
"Zack Mayo" <anonymous@discussions.microsoft.com> wrote in message
news:38F22C3E-B916-496C-9003-2AD6381617A2@microsoft.com...
source table is in alphabetical order. But when I select the dropdown on the
form, the names are out of sequence. I tried sorting in the form on that
field AtoZ but no luck. Any ideas....
|
| Rick Brandt replied to =?Utf-8?B?WmFjayBNYXlv?= on 17 May 2004 |
source table is in alphabetical order. But when I select the dropdown on
the form, the names are out of sequence. I tried sorting in the form on
that field AtoZ but no luck. Any ideas....
The drop-down (actually called a ComboBox) has a RowSource property with a
Query or SQL Statement in it. You need to open that and add a sort in that
query.
|
|
Archived message: Table Order in Access Form (Microsoft Access)
