Search results

=DLookUp("[Citi_IM]","Cleared","Product ='Futures' And AcctNumber= " & [Forms]![Form1]![AccountCombo]) This is currently working But I don't know enough to say Why The textbox in which the account number is populated is on the same form as the combobox Sorry for the hassle. Appreciate the...

The below SQL statement pulled in the correct info but the AcctNumber and Products field were hidden SELECT Cleared.Citi_IM FROM Cleared WHERE (((Cleared.AcctNumber)=[Forms]![Form1]![AccountCombo]) AND ((Cleared.Product)="Futures")); Is it possible to convert this into the Dlookup?

Agreed. I am trying to get the account number at a certain bank when product is futures and account number matches the combo box I copy and pasted directly into the formula bar but still with no luck. Still getting #Name? Does it make any difference that it is a linked excel sheet? Filter...

That is correct. Citi_IM is a field name in the table. I am looking to extract the account number from that field when product type is Futures and Account Number matches a combobox on Form 1

Hey isladogs I tried both ways but seem to have not had any luck. Apologies if I am missing something Going to try and give more details to see if that will help Table name - Cleared (this is a linked excel sheet) AcctNumber - Number format field in Table Cleared Product - Short Text format...

Hi All Hoping you can help with a small issue I am trying to Dlookup an account number from one table (Cleared) where the Product is a "Futures" and the account number matches a combobox Stuck on the below =DLookUp("[Citi IM]","Cleared","[Product] =" & "Futures" And...

I put both headers back into the "field" names and unchecked table name and moved the criteria over to that column as well However, I still don't have the 2nd listbox updating with anything once an item from the first listbox is selected -2nd image

Thank you both for the super fast replies -Removed the 2nd table from the first listbox (oversight on my part) First image shows one table with the field Table name displayed and the result as expected (2nd image) The third image will show column headers (fields) from the helper sheet table...

Hi All New to the forum with no VBA experience. Looking for some VBA help to have a 2nd listbox update based on selections in the first list box Background - I am trying to create a "helper query builder" page for managers in our area with no Access experience but would like to create custom...