Control Source

[SSUTTON]

Hi Everyone:

When Setting up a Combo/ListBox especially a multicolumn what should you use as the Control Source? The Primary Key or one of the visible column headings? Thank you.

[ranman256]

Whatever data field you want to capture, should be in the query (control source)
You DONT have to see the keys if you dont want, using colunmnwidth = 0, but it does have to be in the query.

The combo should
set COLUMNS
set COLUMNWIDTHS

[SSUTTON]

I just want to make sure I understand you.

I have 4 fields that I want to appear in the combo/listbox - ChildsFirstname, ChildsLastName, ChildsDateofBirth,ChildsMCP. These are the Visible Columns that I want to have as column Headings. Can the Control source be another column from the original table that will not appear. I don't want something popping up on the screen that won't make sense to the user. Right now ID comes up and a number appears. I don't want this because it won't make sense to the user. Thank you.