T
Trial & Error
I have a table named "Camper"
using that table, I have a form that allows users to fill in each field.
One of the fields is titled "Enjoyed"
I have turned that field on the form into a combo box.
That combo box has a record source that is a secondary table - titled "Likes"
the "Likes" table has one field; called "likes1"
I have set the feild on the form to "Limit to List"
What I would like to do is have access add any new / unique entries to the
combo box list. I believe this would mean adding the entry into the records
held in the table named "Likes". I also believe I will be having to use the
"OnNotInList" feature by generating an event procedure...
I have read several posts but have been completley unable to get the
"OnNotInList" function to work.
What should my [event procedure] look like for this instance?
using that table, I have a form that allows users to fill in each field.
One of the fields is titled "Enjoyed"
I have turned that field on the form into a combo box.
That combo box has a record source that is a secondary table - titled "Likes"
the "Likes" table has one field; called "likes1"
I have set the feild on the form to "Limit to List"
What I would like to do is have access add any new / unique entries to the
combo box list. I believe this would mean adding the entry into the records
held in the table named "Likes". I also believe I will be having to use the
"OnNotInList" feature by generating an event procedure...
I have read several posts but have been completley unable to get the
"OnNotInList" function to work.
What should my [event procedure] look like for this instance?