filter a text box through a combo box on a form

I would like to know how to filter the information displaying on a text box
depending on the value of a combo box. Example i have a Combo box with Values
"A", "B", "C", "D". I have a query with fields A B C D where each field is a
calculation to determine extended time (A*Qty, B*Qty, C*qty, D*Qty). If I
pick "A" from my combo box i want it to display the value in that field
pertinent to the current record.

To give you a picture of what i am working on let me describe what i have so
far

I have a Table with 5 fields "strSku" strTimeA" "strTimeB" "strTimeC"
"strTimeD". I have another table that will capture an employee's Work
Production. the table has "strID", "strSku", "strOperation"(where operation
is A, B, C, D) "strQty", "strTime". Both "strSku" are linked (relationship).
I Have a query that displays the strSku and Quantity from my Production table
and 4 calculation fields that determine the values of strTimeA*qty,
strTimeB*qty, strTimeC*qty, strTimeD*qty. On my form i have the fields from
my "Work Production Table" where the Operations field is a Combo box with A,
B, C, D as the values, I would now like to populate the Times text box by the
results of the query where it would look up the value depending on the value
of the combo box. Ex. I pick "C" in my combo box i would like my "Times" Text
field to show "strTimeC*qty" from my query and insert that value into my
Production table strTimes' field for that record. unless there is an easier
way to do this other than by a query.

I hope you guys understand what i am trying to do...I have a very difficult
time explaining myself and i am fairly new to access so i don't know all the
language of it yet.

Thank you for any and all help you can give.

.

Relevant Pages

  • Re: Seemingly (and probably) complex re: turnaround time
    ... Create a query based on "tblProduction". ... ReceiptToEntry: Entry - OrderReceipt ... DesignToProduction: Production - Design ...
    (microsoft.public.access.queries)
  • Re: Repost :Crosstab with complex calc field
    ... Totals Query - still excludes 0 values ... > every distinct group ... > Production ProdID LocCode RevItem ChWidth ProdDate NumCheeses ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Referincing Fields
    ... depending on the path and there are about 50 of these types of fields I am ... a query that will create a single units field in my query that will ... than going in and trying to edit a nested Iff statement(I currently have ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compare 1st qtr this year to 4th qtr last year
    ... I know my problem is with the fact that the query the report is based on is ... "KARL DEWEY" wrote: ... It is based on a crosstab query that sums the production numbers by qtr. ... However, obviously, it doesn't work to compare 4th to 1st, because now I have ...
    (microsoft.public.access.reports)