how to create a Search text box and have it retreive associated table data

  • Thread starter David Payne via AccessMonster.com
  • Start date
D

David Payne via AccessMonster.com

OK. i am new to Access but can do anything i am told. This seems like a
simple request but i cannot figure it out.
i have created a database with 6 columns of data. fields are
1. Employee
2. Room #
3. Phone #
4. Floor
5. DEPT
6. a field for hyperlinks

i am trying to create something where the end user can access an html page
(my data access page) type a users first or last name (last is more
important) into a search box, press enter and it will fill in the rest of
the fields. we have about 600 users and although not many will use this the
ones who do need simplicity.
I have found a script that i used to update user name as it is being typed
in the "combo box" that i was going to use for search, but i cannot figure
out the syntax for "on enter" fill in the rest of this form with the
correct data from the DB. i hope this makes sense. I could very easily be
approaching this the wrong way too, so i am open to any new ideas to make
my life easier. i will be happy to clarify if needed.

Thanks in advance, from what posts i have read you guys are awesome.
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top