Dlookup troubles copy value from one table to another using combobox in a form

[David82]

Having troubles getting a value from table A col2 to Table B col4 using a combobox in a form. Where the value in TableA col2 is equal to the value selected in the combobox.

Table A contains :
col1 items(primary key[short txt])
col2 price(Number[Euro])

Table B contains :
col1 ID(Primary key[Auto]
col2 items([short txt]) COMBOBOX (List Table A col1)
col3 Numberofitems (number)
col4 price
col5 subtotal (calculated field)

Tried several methods to do this but lacking the expert knowledge i think
I hope i'm on the good way using dlookup in the first place for this .

 

[pbaldy]

In this case the second method is appropriate. Price changes over time so can be saved with the transaction.

Edit: forgot the link:

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

 

[David82]

Thank you for the help. "pbaldy"

Got the method of displaying the value in the textbox working.
but a little bit confused in where to place the "ME...." command so it saves the value in the correct field and record.

Still struggling with code :banghead:

 

[pbaldy]

That is VBA code which goes here:

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