Add Data With Combobox (1 Viewer)

[Bunga2017]

Dear mr/mrs

could you please help me with the following problem :

If on Product ID = T100

on Description must be : Tshirt
on UnitPrice must be : 15
on Merk must be : W

QTY and Color wil be Manually field.

Thank you in advance for your help

 

[pbaldy]

I would add fields to the combo's row source and use this method:

http://www.baldyweb.com/Autofill.htm

 

[Bunga2017]

Thanks for the reply. I tried both code u mentioned:
=ComboName.Column(2)....this code made the Description text box auto populate but did not save the value in the Main Table.

Please help

 

[pbaldy]

Did you read the part near the end starting with "If your situation..."?

 

[Bunga2017]

I'm beginner in ms access, I was wondering if you could help me !

Thank you

 

[pbaldy]

Where exactly are you stuck? The instructions seem clear to me, but always open for improvement.

 

[Bunga2017]

Dear Paul,

Thank you for your help, do you know how to Clear an Access combo box for entering the next record ?


Thank you in advance for your help

 

[pbaldy]

You can set it to Null or "", probably in the current event. If it's bound it should clear itself.