Navigation Forms

[ericur]

I have a database with a navigation form. The form provides the users the ability to search last name or by location. Users have little or no knowledge of Access. I wish to provide instructions on how to proceed the front page. How can I enter the text for the instructions?

[ranman256]

The user need not know access if you make forms & queries for them.

make a form that shows all records ,continuous records.
In the header, put unbound controls for the user to enter search criteria.
When user clicks the Find button, Test all controls for a possible filter then build the where clause:

sub btnFind_click()

sWhere = "1=1"
if not isnull(cboState) then   sWhere = sWhere & " and [state]='" & cboState & "'"
if not IsNull(txtName) then    sWhere = sWhere & " and [Name]='" & txtName & "'"
if not IsNull(cboGender) then    sWhere = sWhere & " and [Gender]='" & cboGender & "'"

 'then filer
if sWhere = "1=1" then
  me.filterOn = false
else
  me.filter = sWhere
  me.filterOn = true
endif
end sub