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?
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?
Last edited: