Search results

  1. C

    Form working properly alone, but gives error when combined with other forms

    I have changed the needed information within the query of the combobox in the subform for it to work. I will have many forms that use this subform, does this mean I need to just leave it as a regular form because there is no way to have a subform referenced in many forms? It works in one of my...
  2. C

    Form working properly alone, but gives error when combined with other forms

    This is a screenshot of the form NewMetalF with in form NewExternalPartF within form NewQuotationPartF. There are internal and external parts. The NewQuotationPartF has a combo box for external or Internal, which determines which form becomes visible. Then within NewExternalPartF the NewMetal...
  3. C

    Form working properly alone, but gives error when combined with other forms

    It is a subform in a way, I want it to open on the click command. But I don't know that there is really a lick between the fields. This is the relationship between the two tables.
  4. C

    Form working properly alone, but gives error when combined with other forms

    Yes. Its open within another form.
  5. C

    Form working properly alone, but gives error when combined with other forms

    HI, I have a form "NewMetalF" that has three combo boxes. The first one is used to choose "Precious Metal" or "Base Metal". The second one shows all the metals based on the first combo box. When I open the form in form view alone the combo boxes work flawlessly. I run the form "NewMetalF"...
  6. C

    Filtered TextBox Value

    I have the values Concatenated in another field in the query. I know which column this is. How do I get the value from the market that I want?
  7. C

    Filtered TextBox Value

    I have the code now that gets the price based on the metal from whatever column I have specified. I just need to get the column in the control source property to look at the market selected. using the column names from the combo box metals?
  8. C

    Filtered TextBox Value

  9. C

    Filtered TextBox Value

    combo1: OptionPreciousOrBaseQ combo2: OptionMetalsListQ combo3: OptionMetalMarketQ
  10. C

    Filtered TextBox Value

    I can get a price with the column command based on the metal name. I cannot get it to use the Market that I want.
  11. C

    Filtered TextBox Value

    The MetalMarketID only corresponds to the ID field in my MetalMarketT table that I have a query based on for the combo box.
  12. C

    Filtered TextBox Value

    I think using the Column of the combobox Metals will be a better method. the combobox Metals has 7 columns. The last 4 of which are the 4 Markets and their prices. I want to make the text box = [cboMetals].Column(4 '&' 5 '&' 6 '&' 7) '&' Where ([cboMetals].Column = "[cboMetalMarket]")
  13. C

    Sequential Number Dlookup

    Oh I see now.
  14. C

    Filtered TextBox Value

    This is what I have so far. Control Source = =DLookUp("[LME] & ',' [COMEX] & ',' [LMBA] & ' ' & [EnglehardFab]", [OptionMetalsListQ], "[Fields]=" & [cboMetalMarket]) The only place where I am unsure what to put is where I put [Fields].
  15. C

    Sequential Number Dlookup

    The NewQuotationQ is a query
  16. C

    Sequential Number Dlookup

    Control Source =DLookUp("QuotationNumber","NewQuotationQ","[QuotationID]=" & DMax("[QuotationID]","[NewQuotationQ]"))
  17. C

    Filtered TextBox Value

    Fair enough. I will be back with something shortly. Thank you.
  18. C

    Sequential Number Dlookup

    Thank you to All that helped. I got it to work.
  19. C

    Filtered TextBox Value

    How will I address that I want the column from the metals list query that is equal to the selection in a combo box? The Prices are in 4 different fields in a table. what goes in the expression?
  20. C

    Filtered TextBox Value

    HI, I have a form that has 3 combo boxes and a text box that I want to be a lookup. I have a little experience with DLookUp, but I do not think that will work here. The three combo boxes are linked to queries, and Tables. The first combo box is for choosing "Precious" or "Base" metals. The...
Back
Top Bottom