By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Using Combo box and text box to Query table

P: n/a
Im just a beginner using MS Access 2002. I have a database set up
with only 1 table and need help searching the database. I would like
the search to be similar to a web search interface.

I have a form with a combo box filled with State/Province names a text
box where the user can type in the date and a text box where the user
may type in a keyword. Hitting the search button would open up a new
form and retreive information based on the search criteria. The user
may edit or print a report then.

So basiscally a search by State Name/Province or Date or Keyword.
Please help. Thank you!

Zifah
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Look at creating a form then a subform. There is a built in Wizrd for this.

--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"Steve Zifah" <ha************@ec.gc.ca> wrote in message
news:c6**************************@posting.google.c om...
Im just a beginner using MS Access 2002. I have a database set up
with only 1 table and need help searching the database. I would like
the search to be similar to a web search interface.

I have a form with a combo box filled with State/Province names a text
box where the user can type in the date and a text box where the user
may type in a keyword. Hitting the search button would open up a new
form and retreive information based on the search criteria. The user
may edit or print a report then.

So basiscally a search by State Name/Province or Date or Keyword.
Please help. Thank you!

Zifah

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.