Can't populate table when select an item in combo box

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Hi all
I can select an item in the combo box and I want that item to
automatically entered into a temporary table.

Can someone tell me the code to do this. Please.
 
Only post to one NG at a time.

The combo box does save the field that you select as the control source.
 
Rolls said:
Only post to one NG at a time.

The combo box does save the field that you select as the control source.
Click to expand...

Sorry, I've only recently registered on Google. Didn't know I can't
post to multiple NG. I thought I can get an answer quicker. But I
really need help on this one. Please advise


I am new to Access 2000

I have 4 tables, 1 main form and 1 subform.
Table 1 is called "ProductTable1". Table 2 is called "ProductTable2",
Table 3 is called "ProductTable3", Table 4 is called "temptable"
Form 1 is called "frmProductForm" and subform is called
"SelectSubform"

I've put 3 combo boxes(cbo1,cbo2,cbo3) in form 1 "frmProductForm" and
they are bound to "ProductTable1,ProductTable2,ProductTable3"
individually. This let's me
select the items.

HERE'S WHAT I WANT TO DO!
========================
I want to be able to select an item from one of the combo box and that
item will automatically populate the "temptable" and if I select
another item from another combo box, it will automatically populate
"temptable" and again and again.

I believe I need some sort of VBA code that need to be in the "On
Change" properties of the combo boxes.

Please advise

Many thanks in advance
 
Back
Top