Forum Discussion

PercyPercian's avatar
PercyPercian
Copper Contributor
Oct 19, 2026
Solved

Setting value to a second column of a ComboBox not Showing

Hello everyone!   There's a combobox (cboPurDate) in a form (Purchasing) as follows: Row Source (cboPurDate):  SELECT DISTINCT Purchasing.PurDate, Format([PurDate],"0000\/00\/00") AS [Purchasing ...
access
  • Gustav_Brock's avatar
    Gustav_Brock
    Oct 20, 2026

    All you need is to bind the first column:

    Bound Column: 0

    Then set the Value and requery the form:

    Me!cboPurDate.Value = 20261019
Me.Requery
Gustav_Brock's avatar
Gustav_Brock
Iron Contributor
Oct 20, 2026

All you need is to bind the first column:

Bound Column: 0

Then set the Value and requery the form:

Me!cboPurDate.Value = 20261019
Me.Requery