Combo Box to Subform

R

Revned

Hello,
I have my main form with a subform name [OrderSubform subform]
I have a [Combo127] with a Row Source:
SELECT OrderSubform.[Item Code] FROM OrderSubform ORDER BY [Item Code];

1.) i want to accomplish that every value i selected from my [Combo127]
it will displays to subform column like the description to Descriptiion
column, quantity to Quantity column, price to Price column, order to Order
column, total to Total Amt column

Description Quantity Price Order Total Amt

2.) i have a cmdClear button i want to accomplish that when i clikck this
button
it will clear records that displays on the subform

3.) i have a cmdSave button i want that when i click on it, it saves to my
qrySales all records that i have in my subform and what i have in my main
form too to be save in qrySales

i am using access 2003

was all of this are possible? pls. help me too if codes are necessary..

thank you very much...thanks for this site
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Subform 0
Combo and subform 2
subform in main form 2
sum amount in my subform to text box in main form 1
subform total to mainform 4
main form - with subform 1
Query - Table 3

Top