hi all,
I have made an access database which has 2 tables namely order and order_details which have one to may relation (order_no-->order_no).
I want to create a form where order_no from order table are populated in combobox. Upon selecting one order number from the combobox, I want to display sum of prices in corresponing records in order_details table.
How?? I have tried this with
UNDER _click event of combobox
text1.controlsource=SELECT SUM(price) FROM order_details WHERE order_no='"& combo1.text &"'
text1.requery
But this did not work. when i click on combobox , '#Name?' is displayed
Thanks in advance
Enter your message below
Sign in or Join us (it's free).