Form Information in Tables

M

margaret

I have two tables ... "TBL_Ticket_Price"
and "TBL_Tickets". In my
form, "FRM_Tickets", "TBL_Tickets!Type" is a combo box
that references "TBL_Ticket_Price!Type". When I
update "Type", "TBL_Tickets!Price" on my form is
automatically updated with the correct "Price"
from "TBL_Ticket_Price". However, when I look at my
table "TBL_Tickets", the field "Price" is not updated.
Why would it show on my form but not in my table?
 
T

Tim Ferguson

However, when I look at my
table "TBL_Tickets", the field "Price" is not updated.
Why would it show on my form but not in my table?

Have you set the combo box ControlSource property to the correct field?


Tim F
 
Top