Table item order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Table A has employee names, not in order, just as they come to me from human
resources. I have a form with a drop down that references Tbl A. What I
want is for those names to drop down in last name ALPHABETICAL order. How do
I do this?

2nd question: Is there a way to have my form open in such a way that it goes
right to the next record that needs to be filled instead of number 1?

TIA for your help. You're a great group.
Sam
 
Add SORT BY [YourLastNameField] to the SQL SELECT statement in the
record source.

You can change the Data Entry property to Yes and when it will open to a
blank record.
 
Table A has employee names, not in order, just as they come to me from human
resources. I have a form with a drop down that references Tbl A. What I
want is for those names to drop down in last name ALPHABETICAL order. How do
I do this?
Click to expand...
Create a query and sort the names however you wish there.
Use that query as the rowsource for the combo box.
2nd question: Is there a way to have my form open in such a way that it goes
right to the next record that needs to be filled instead of number 1?
Click to expand...
Always open to a New Record?
Code the form's Open Event
DoCmd.RunCommand acCmdRecordsGoToNew
 
Add SORT BY [YourLastNameField] to the SQL SELECT statement in
the record source.
Click to expand...

ITYM .. ORDER BY ... and the property name in the combo box is the
RowSource


B Wishes


Tim F
 
Back
Top