Query Forms

  • Thread starter Thread starter Scott Johnston
  • Start date Start date
S

Scott Johnston

Help,

This may be pretty basic but I cannot figure it out. I
have a table that all it is used for is to look up parts.
I created a text box on a form. On exit from the text box
it applies the filter to pull the information in for the
item typed into the text box.

This is where I get stuck. I need to be able to clear
that filter so the customer can enter another item so he
can search for it. Everything works the first time but it
never clears the filter or searches for the next item.

Could someone please give me a hand with this?

Thanks
Scott
 
Instead of applying a filter this way place a combobox on you form that is
populated with all the parts from your parts table. When you add the
combobox make sure the Control Wizard is selected on the Tool Bar before
adding it. It'll prompt you for info. In the first popup window select the
3rd option. Click next. Select the field(s) you want to lookup. Click next.
Size the columns if you want. Click next. If you selected more then one
field for the combobox your next window will ask you what field to use as
the looup field. Select the field. Click next. Select remember value for
later use. Click next. Click finish. If you only selected one field for
the combo then you wont get these last few popups so your done. Now when
you select an item in the combo your will be taken to the part you selected.
Hope it helps!
 
Back
Top