Some kind of subform combo box mask?

[thrainpa]

How can I make some kind of subform combo box text mask?

Hi, I'm having trouble with a specific issue in my database.

Basically I have 2 tables, let's call them Subform and List,

Subform exists basically to modify a table in a form, BUT one of the fields is a number called 'listID'.

List has 2 columns, one that is also the listID number, and another that is text to related to that number.

What I want, is to be able to open the combo box to modify the 'listID' number inside Subform, but in the combo box itself, to show the corresponding text in List.

Can anyone help me here?

 

[Uncle Gizmo]

I am having great difficulty ferriting out the essence of your question.

The only sensible question I can think to ask is:

Is 'listID" an automatically generated auto number? Or is it a list that can contain the same number more than once?

 

[thrainpa]

Yeah it was very hard to word; listID was a non-generated number that could not appear more than one, the list table itself is static, so you could theoretically treat listID as the primary key.

But it doesn't matter now I found a little workaround.
A better way to word my issue is basically, I wanted the combo box to show up with text strings but the input value to be the integer. In the end I figured out away to do it by making the control source the 'listID' in 'Subform', listing both columns from 'List' in the combo box in the rowsource, and making the 'listID' column Width 0cm.

But thank you very much anyway for trying to decipher my terrible explanation to try and help. xD