Make Search Field in Access form 1

[bmjavakid]

Hello,

I never do any work with Microsoft access and I was thrown into a small project using it. How do you make a search field in an access form (by the way I am using access 97)? Is there a wizard for creating such fields, or does it have to be coded?

Any and all help is very much appreciated.

Thanks!

 

[fneily]

In the Design View of your form, create an UNbound combobox (do not use the wizard) in the form header section.
Open the property sheet for the combobox and on the Rowsource option place a SQL statement such as the following:

Select [Itemnumber] From [tblParcel] Order By [Itemnumber];

Then on the AfterUpdate event of the combobox place VBA code like the following:

Private Sub shaid_AfterUpdate()
Dim R As DAO.Recordset
Set R = Me.RecordsetClone
R.FindFirst "[Itemnumber] = " & Chr(34) & Me![comboboxname] & Chr(34)
Me.Bookmark = R.Bookmark
Me![comboboxname] = Null
End Sub

[Itemnumber] is the name of the control on your form you want to populate.

 

[jmk418]

hi
i assume your using a txt box and typing in your search criteria
i use access 2002 but the code should be similar

strwhere = txtsearch.text

DoCmd.OpenForm "table name", , , "[field you are searching] = (" & strwhere & ")"

hope that helps

 

[Dreamboat]

I'm a WIZARD user myself, so I wrote this:

http://www.theofficeexperts.com/access.htm#SearchForm

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121

 

[Dreamboat]

Oh...and I double-checked, and it should work in 97 too.

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121