Good morning...
Not sure if this is Forms or Programming related; could be a little of both .
I indicated previously I am building an IT Helpdesk type tracking system for user accounts, trouble tickets etc. When a request comes in, 95% of the time things are standard; ie user needs an account unlock, they will also need a password reset; this is just how the security for the system in question works.
I created a form for the ticket requests with a combo box to allow the tech to select all of the appropriate ticket types so they only need to enter a single date of receipt/completion. Problem is, I didn't realize that the multiple selections would appear as a single record and am guessing that any query or report would hone in on identification using the multiple words and not count individual terms.
Due to our reporting requirements I need to be able to single out the ticket types. Is there a way to break apart the selections in the combo box, say an account unlock, account update and password reset, so they would record as three separate records?
Or am I wrong in guessing the system wouldn't separate out the terms even if multiple terms are contained as a single record?
Thanks
TK