Defualt value in subform

[DraGo150]

I know this will probably very easy to fix but it is driving me crazy..

I have a main form (frm_InventoryData) with a subform (frm_Transfer_sub).
On the main form there is a combo box [Location] pulling from (tbl_Cubical, [Section], and I have the [From] Default Value on the subform pulling ( =([Forms]![frm_InventoryData]![Location]) ) .

The problem is that it is pulling the primary key instead of the text which is displayed on the main form [Location]. I have even tried to change the Control Source to point to the main form and it is doing the same thing.

Please help, and enlighten me.

 

[dhookom]

Why would you ever want to store text rather than the key value? This is not a typical usage of primary and foreign keys.

If you really need to store the text, change the Row Source of the combo box to exclude the key field.

Duane
Hook'D on Access
MS Access MVP

 

[hermanlaksko]

On your combo box under format set Column count to 2 and Coulmn widths to 0;3

Herman
Say no to macros