Search Field on entry form

[Rhubie]

I have a form to enter data, I would also like to have a search field on this form so that someone can also do search by lastname. I have tried to add a combo box - but it is not working.



Can I have a search field on this same form? If so, how would I go about getting it to work?

The information that I have found says to use the wizard and select "Find a Record on my form that is based on the value that I selected in the Combo Box"
this does not show in the wizard in Access 2010.

[NTC]

when the form is in design view; and you drag/add a combo box onto it - the wizard launches and provides 3 choices...the 3rd choice is what you need....

if the wizard is not launching then you have some other issue - that may be as complicated as an installation problem or as simple as misunderstanding which icon is actually the combobox control....

hope this helps

[Rhubie]

Thank you - I got it working - it must have been how I was dragging it - sometimes there are only 2 options. Can I sort the combo box list alphabetically and then can I clear the box if the person wants to enter a new record?

[Missinglinq]

...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.

...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.

...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:

Private Sub Form_Current()
 If Me.NewRecord Then
  Me.ComboboxName = Null
 End If
End Sub

Linq ;0)>

[Rhubie]

Thank you

If I add a new record - the value stays in the find search box (combo box) is there a way to clear that?

[Missinglinq]

Sorry, see my edited post above!

[Rhubie]

How can I tell if the Form is Bound to the Recordsource?

Can I have multiple search fields on a form?

[Missinglinq]

In Form Design View, go to Properties - Data; is there anything in the Record Source Property?

You can search as many Fields as you want, but some may or may not be of any real use.

Linq ;0)>