Novice needing help

  • Thread starter Thread starter Walt
  • Start date Start date
W

Walt

Hi hopefully someone can assist me.

I'm trying to build a query that works with a drop down list. What I want
to do is be able to select an item from my source column in my table. I have
multiple sources in this column. When a specific source is selected, it
returns all the information in my table with the same source. Is there a way
to do that or do I have to know sql?

Thank you

Tony
 
Put this in the criteria of the query in design view --
[Forms]![YourFormName]![ListBoxName]
 
Karl thank you for taking the time to respond. I do appreciate the help.

I must be doing something wrong. I put the following in but nothing shows
up other than a blank cell:

[Forms]![frm_Sources]![Source]

I have duplicates in the source column. For example:

Book
Report
Book
E-file
E-file
E-file

Will that cause a problem?


KARL DEWEY said:
Put this in the criteria of the query in design view --
[Forms]![YourFormName]![ListBoxName]
--
KARL DEWEY
Build a little - Test a little


Walt said:
Hi hopefully someone can assist me.

I'm trying to build a query that works with a drop down list. What I want
to do is be able to select an item from my source column in my table. I have
multiple sources in this column. When a specific source is selected, it
returns all the information in my table with the same source. Is there a way
to do that or do I have to know sql?

Thank you

Tony
Click to expand...
Click to expand...
 
but nothing shows up other than a blank cell:
Did you make a selection in the drop down before running the query?

Duplicates will not matter.
--
KARL DEWEY
Build a little - Test a little


Walt said:
Karl thank you for taking the time to respond. I do appreciate the help.

I must be doing something wrong. I put the following in but nothing shows
up other than a blank cell:

[Forms]![frm_Sources]![Source]

I have duplicates in the source column. For example:

Book
Report
Book
E-file
E-file
E-file

Will that cause a problem?


KARL DEWEY said:
Put this in the criteria of the query in design view --
[Forms]![YourFormName]![ListBoxName]
--
KARL DEWEY
Build a little - Test a little


Walt said:
Hi hopefully someone can assist me.

I'm trying to build a query that works with a drop down list. What I want
to do is be able to select an item from my source column in my table. I have
multiple sources in this column. When a specific source is selected, it
returns all the information in my table with the same source. Is there a way
to do that or do I have to know sql?

Thank you

Tony
Click to expand...
Click to expand...
Click to expand...
 
Back
Top