Let's go back to your statement that you don't understand this line:
"To filter records in a combo/listbox based on the value selected in another
combo/listbox, you can use a stored query which uses the first control's
value
as a parameter"
Could you list the terms in this statement which you don't understand?
- Turtle
"Rated R1" <ratedr1@aol.com> wrote in message
news:20040821093314.16712.00002751@mb-m22.aol.com...[color=blue]
> I wrote this before in the NGs, so I am going to paste the responses that[/color]
I got[color=blue]
> and see if someone can please help me. Email me and we can set something[/color]
up as[color=blue]
> Id even be willing to pay for your time to get me to learn this procedure:
>
> MY ORIGINAL POST:
> I am trying to create a database for my small business. I have typed a[/color]
bunch[color=blue]
> of information in a table in 5 columns (style, mm, karat, quantity, labor
> cost). We have different labor costs obviously depending on what[/color]
combination[color=blue]
> those first 4 factors are for example respectively in the columns[/color]
mentioned[color=blue]
> above
> (abc, 5mm, 14karat, 10pieces), would be $5 for the labor cost. What I[/color]
want to[color=blue]
> be able to do is produce a query (pref drop down or similar), that would[/color]
take[color=blue]
> what I chose from the style, mm, karat, and quantity, and display the[/color]
resulting[color=blue]
> labor cost. In the one above the labor cost would be $5, however if I[/color]
changed[color=blue]
> say just the karat to 18karat, the labor would display $6. Any help would[/color]
be[color=blue]
> GREATLY appreciated if you can email me it might be easier. If you think[/color]
youd[color=blue]
> need to see what I have typed so far please email me and I can send what I[/color]
have[color=blue]
> so far..
>
> THEN A RESPONSE:
> Access already contains a tool which may do all you need.
> Open your table.
> From the menu, select Records - Filter - Filter by Form.
> The table will change to a single record, with drop boxes for each field.
> Fill in the fields, and click Filter - Apply Filter.
> Your table will now show only the records which match your entries.
>
> THEN I WROTE:
> Yes this is similar to what I want to do...however with a few differences.
> First off in the first column I will choose "style a", i want the next[/color]
column[color=blue]
> to only give me the results that fall within that category. Then from[/color]
those[color=blue]
> choices I select for example "4mm", then I want the third colum to give[/color]
only[color=blue]
> the choices that fall within the "style a" + "4mm" category. Then in that
> column I choose "14karat", then in the 4th I want only those that fall[/color]
within[color=blue]
> "style a" + "4mm" + "14karat", and so on until the 5th column when there[/color]
will[color=blue]
> be the result
>
> THEN I GOT THIS
> read this, it solves your problem:[/color]
http://www.mvps.org/access/forms/frm0028.htm[color=blue]
>
> SO MY FINAL RESPONSE WAS:
> I will pay someone a reasonable price for leading me to the ulimate answer[/color]
and[color=blue]
> helping me learn access for this result
>
> thank you so much for leading me to that page...it will be of great help[/color]
in the[color=blue]
> future, however. The problem is on my computer it came up in Chinese.[/color]
Wel[color=blue]
> actually it looked like English, but when I read the words out loud it[/color]
sounded[color=blue]
> like Chinese to me :-) For example..in this line :
> To filter records in a combo/listbox based on the value selected in[/color]
another[color=blue]
> combo/listbox, you can use a stored query which uses the first control's[/color]
value[color=blue]
> as a parameter
> One of the problems is, since I am not database literate, I would need to[/color]
learn[color=blue]
> how to do this from the beginning. All that I have typed out is the table[/color]
with[color=blue]
> the 5 columns (and even then I found out I need a primary key for some[/color]
reason[color=blue]
> which I didnt have). I haent written a query for any of the columns yet,[/color]
so I[color=blue]
> cant even get to the point of the page that you have shown me. Is there[/color]
any[color=blue]
> further help that you could provide me? (or if I send you the database[/color]
can you[color=blue]
> write one quick query for me to show me?). I really want to get this[/color]
done, and[color=blue]
> once I learn how to do something, I never forget it
>
>
>
> If anyone can help me PLEASE email me and we can talk. I need this for[/color]
work as[color=blue]
> soon as possible, thanks in advance,
> Scott
>[/color]
