need a "find a record" code

C

Cheyenne

hi all. I have a form in which i've created 3 fields: Acct name, Acct
number, & Tel. number. Is there a way to create a "find record" command which
takes me directly to the number i've input into the corresponding field.
i.e. in the tel. number field, after the number is keyed, click the enter
command button and it will open a query which takes me directly to the
record. When I use the command wizard to create this type of command, I have
to re-enter the number in the "find record" menu box that pops up. I thought
that there might be a more direct way to do this. I hope i've made my
question clear.
Thanks.
-Cheyenne
 
6

'69 Camaro

Hi, Cheyenne.

Instead of opening up a query that shows your desired record, why not just
jump directly to the record you want from within your form? Tom Wickerath
wrote an easy, step-by-step tutorial on how to create a combo box on your
form that, when an item is selected, will display the correct record.
Please see Tom's article, "Using a Combo Box to Find a Record" on this Web
page:

http://www.Access.QBuilt.com/html/find_a_record.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top