Combobox selecting one available option

[dylcon]

Hello, I currently have a combobox that is being populated depending upon another combobox, and there is only one selection, but it is not selecting this. I want to have it selected so it can be available only for a visual for the user; I don't want them to be able to change it. If there is a better way to do this, I am open to suggestions. Thanks in advance

[Missinglinq]

Since you're only retrieving one value, instead of using Cascading Comboboxes, which is what you're now doing, create a Textbox, and in its Control Source use the DLookup function to retrieve the value, using the same 'WHERE' clause that you used when setting the RowSource of the secondary Combobox.

By populating the Textbox using its ControlSource, in this way, it will be a Read-Only Control, which is what you want.

Linq ;0)>

[dylcon]

This field is not bound to a table. Only to a query so will that make a difference? Should I set the ControlSource with VBA? I am not familiar with its syntax..

[dylcon]

Now I have this:

tblPartInfo.RawNumber Where tblPartInfo.PartID = 15

, but the textbox simply has "#Name?" in it.

Additional: 15 is the PartID that is in the combobox at the time this was taken from the ControlSource.

[dylcon]

Does anyone have any ideas?