Hello All,
I am drawing a blank and hoping someone knows the answer. I am missing something.
I have a From that has a Category data card that uses a combo box to select the Category from the Category table. The combo box only allows for one Category to be selected
There is a CategoryID data card on the form, hidden, and I need that field filled in with the ID of the Category table of the selected Category from the combo box.
If the Category is updated for a record then the CategoryID would be updated with the new ID.
I have tried a number of ways to get this to work and I an not having any luck.
Thanks in advance for your help.
Kind regards,
------------------------------
John Heck
------------------------------