using combo box to input a value in a table

[stickooo]

Hi,

I have a table calls "period", that has period id, and a date.

I would like to use a combo box (in form "bills&quot to show the values of table period, and then save it to field "time" in table "bills"

So far, I am able to do it. But the problem is, instead of saving the date (from "period&quot, it saves the period id to the field

Anyone know how to fix this in a simple way ?

thanks

 

[OldTom]

Assuming your combo box is picking up both fields, i.e. Id and period, then Id will be in column(0) of the combo and period will be in column(1)
so set field "time" in table "bills" to comboboxname.column(1)

 

[stickooo]

Hi,

This sounds like the solution. But, I don't know where should I set it (comboboxname.column(1)).

Can you explain it more.

thanks