Re: How to in query



I left my code as is, when I select a plant the respective suppliers
populate for that plant. What and how should I attempt to do what I
want? Does it make sense on what I want?


On Oct 3, 10:03 am, Marshall Barton <marshbar...@xxxxxxxxxx> wrote:
ryan.fitzpatri...@xxxxxxxxxxx wrote:
thanks, I actually this allen brown example for the basis of my
filtering. Like i mentioned the filters work I just wanted to add
alittle extra user friendly feature. basically I wanted to have the
supplier cbox to show all suppliers, and only when a plant is
selected, the a filtered list of suppliers for that plant will show,
thsi way a person can search for any supplier or any supplier linked
to that selected plant.

If you understand Allen's example code, then it should be a
small modification to make it do what you want.

I still say you should start out by adapting the code to set
the row source to do what you have now, then I can suggest a
modifcation to deal with your question.

--
Marsh
MVP [MS Access]

.



Relevant Pages

  • RE: How to in query
    ... Private Sub Form_Open ... RowSource back to show all Suppliers. ... if I click plant #8103 it filters everything that plant 8103 ... Now I have a supplier combobox that ...
    (microsoft.public.access.formscoding)
  • Re: How to in query
    ... that filter table records in the detail. ... if I click plant #8103 it filters everything that plant 8103 ... Now I have a supplier combobox that ... This pulls all associated suppliers for which ever plant is selected. ...
    (microsoft.public.access.formscoding)
  • Re: How to in query
    ... selected, the a filtered list of suppliers for that plant will show, ... that filter table records in the detail. ... Now I have a supplier combobox that ...
    (microsoft.public.access.formscoding)
  • How to in query
    ... I have a combobox called cboxPlant and another called cboxSupplier. ... that filter table records in the detail. ... if I click plant #8103 it filters everything that plant 8103 ... This pulls all associated suppliers for which ever plant is selected. ...
    (microsoft.public.access.formscoding)
  • Re: How to in query
    ... Private Sub Form_Open ... RowSource back to show all Suppliers. ... if I click plant #8103 it filters everything that plant 8103 ...
    (microsoft.public.access.formscoding)