I have a form with a CheckoutLog table as the recordsource. I have a combobox set up for "Find a record on my form based on the value I selected in my combo box." It works. I have extra criteria/order by in the query of the combobox itself to return the last individual with the matching equipment ID. This works, if I scan/type in "001001" it DOES pull up the last entry in the table based on date and if that equipment ID matched. I thought this was my final answer yesterday.
I realized today, however, that when I make an entry into that combobox to search, it's altering/editing my 1st record's "Equipment ID" field. I suppose I could work around this by simply putting a blank record on my 1st entry and then it wouldn't matter if it edited the first entry every time, but, I'd like the table to be useful data, even if it's just one blank record.
So, 1, how do I get it to stop editing my 1st record? and/or 2, how do I default my form to open with null data instead of an actual record until data is entered?