Originally Posted by
Rhubie
...sometimes there are only 2 options...
The third option only appears if the Form is Bound to a RecordSource. Unless the Form is Bound to the appropriate Table/Query and has Controls on it, to accept/display the retrieved data, the Access Gnomes have no way to automatically perform the task.
Originally Posted by
Rhubie
...Can I sort the combo box list alphabetically...
The easy way would be to
- Create a Query from the Table, using the Query Wizard
- Go into the Query Design View and sort by the Field
- Create your Combobox based on the Query rather than the Table.
Many experienced developers always base Forms on Queries, even when there is only one Table involved. Queries make data manipulation easy (as in this case) and many feel that accessing the data through a Query, rather than directly through the Table, adds a layer of protection.
Originally Posted by
Rhubie
...can I clear the box if the person wants to enter a new record?
Sorry, not sure I understand this. If you want the Combobox to reset, when the user goes to enter a New Record, something like this will do it. Simply replace ComboboxName with the actual name of yours:
Code:
Private Sub Form_Current()
If Me.NewRecord Then
Me.ComboboxName = Null
End If
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007