I have a combo box with limit to list selected, but it doesn't actually limit to the list! It lets users enter data and save it to the list. Is there a way to change that without turning it into a dropdown box only?
I have a combo box with limit to list selected, but it doesn't actually limit to the list! It lets users enter data and save it to the list. Is there a way to change that without turning it into a dropdown box only?
Did you set the AllowValueListEdits Property to NO?
(right below the Limit to List property)
Also make sure there's no code in the NotInList event.
I am so blind. That was it lol.
I have a timestamp on my records that is called [tstime] and it is set to the format for 24 hours,
but when I go to edit it from a subform it shows 11/8/2017 6:39:06 PM that format, and they have to erase all of it to enter 19:20 or whatever time it is (in military time)
How do I have it store only the military time?
Sounds like when you populate the field, you include the date. A date/time field stores the date and time together as a double, with the integer portion representing the date and the decimal portion the time.
Why are you editing a timestamp field? A timestamp is (usually) for knowing when a record is created - nothing more.