Search results

Can I ask you one more question please? I notice that on my form the cascading isn't working anymore, trying to figure that out, it keeps saying

It's working! Thanks a MILLION !! :)(y)(y)👌‼

getting a

Please find attached.

Thanks, tried but the combobox stays empty... :unsure:

=DLookUp("ExchangeRateID";"ExchangeRateT"=DMax("ExchangeRateDate";"ExchangeRateT";"CurrencyID=" & [CurrencyID])) no luck with this one :unsure:

Yes, indeed. OK, I'm trying to combine the DMax with DLookUp.

I kept ExchangeRate and ExchangeRateDate both visible.

The value of the combo box will show the exchange rate but from the drop down you can select by month. Property setting column widths.

Yes, I did.

Hi Below is a screenshot of the form when starting a new record, as you can see, the default CurrencyID is there, EUR, but the ExchangeRateID remains empty.

I set default value for CurrencyID to EUR (CurrencyID = 1).

Yes, I have.

Below screenshot of the form

Hi Jdraw, CurrencyID list the available currencies. Table: CurrencyT CurrencyID PK CurrencyName (EUR, USD, NOK, HKD, GBP) CurrencyT CurrencyID currency 1 EUR 2 GBP 3 HKD 4 USD 5 NOK

Dear experts, I’m trying to set a default for a field (ExchangeRateID) on my form but I’m not getting any value (?) On my form PurchaseOrderItemsFSub (the recordsource is the table PurchaseOrderItemT) I have following fields: POItemID PK POID FK ProductID FK ProductBrandID FK ProductModel...

Thanks Micron, I tested and could query the capex number with a capital letter.(y) I thought to get the ones with a small letter I'd change to "AS [Lower] FROM" but hat would have been too simple I guess as it doesn't work... :unsure:

"you need to find all records where the last character is Upper case for one search and not Upper case for the other search. Is that correct?" Yes, that's correct. The last value is always a letter. The Capex is a form which management needs to sign for approving a purchase, when the value is...

Thanks Micron. I want to be able to query both options: small and big, hence get a list of all the small capexes (AEANT19a, AEANT19b, AEANT20a, AEANT20b, AEANT20c...) and a list of all the big capexes.

Thanks Doc!!(y):)