search data on form

[ruby]

hi there, can someone pls help me?

I have a parts inventory form and I'd like to find an
specific part number by creating a text box to enter the
parts number and when I hit enter it's going to show me
that data on the form? how do I Do this?

pls help..

thanks in advance,
ruby
(e-mail address removed)

 

[Reggie]

Ruby, I would use a combobox to allow the users to select the value. If you look at your Toolbox
toolbar you'll see a wand with stars button. Make sure that it's selected. This is the wizard
button. Now click and place a combobox on your form. The wizard will launch. Select the option to
find a record on your form....! Continue through the wizard and you'll be set.

Hope this helps!

 

[Guest]

Hi reggie, thank u so much, I really really appreciate it.

I added the combo box and it works But I was just
wondering, the inventory form that I am doing could have
like thousand of parts, so it means that I have to look in
the combo box with 1000 part #'s? Is there an easy way?
Like for example when I enter the part number or
description on a text box then the data's will show on
form?

sorry i'm new to ACCESS and I'm really confuse.

Thanks and Godbless.

Ruby
(e-mail address removed)

-----Original Message-----
Ruby, I would use a combobox to allow the users to

select the value. If you look at your Toolbox

toolbar you'll see a wand with stars button. Make sure

that it's selected. This is the wizard

button. Now click and place a combobox on your form.

The wizard will launch. Select the option to

 

[Reggie]

Ruby, If you open the property window for your combobox while in design view. Click the data tab and
set the Auto Expand to yes. Now you can start typing in the combo and it will look for matches and
fill them in for you. Give it a try and see if this is what you are talking about.

 

[John Egan]

You don't have to scroll. Just type what you're looking for and it will
select records as you type

John