Hi,
I am using Dlookup in access form on a combo-box (afterupdate macro) to populate the next related dropdown.
But it only fetches the result of the first data entry in that column.
ex:
Column1 is Customer, Column2 is Product
Cusomter Product
THE Totality DEPOT/TED CROSS 12 X 12 ACTIVATOR WITH SLIT/1MSHTS
THE Totality DEPOT/TED CROSS 12 X 18 ACTIVATOR WITH SLIT
THE Totality DEPOT/TED CROSS 12 X 18 ACTIVATOR WITH SLIT (1000/BOX)
THE Totality DEPOT/TED CROSS 12 X 18 ACTIVATOR WITH SLIT /1M SHTS
THE Totality DEPOT/TED CROSS 12 X 18 ACTIVATOR WITH SLIT/1M SHTS
THE Totality DEPOT/TED CROSS 12 X 24 ACTIVATOR WITH SLIT/1M SHTS
It only fetches 12 X 12 ACTIVATOR WITH SLIT/1MSHTS and not the rest, i.e. I want a "select * from customer_product where customer="THE Totality DEPOT/TED CROSS" event.
Meaning all options to show in the dependant drop-down.
Bookmarks