Was handed a project to add data to an excel sheet. Because data were concatenated and some would keep and some would change and there were some rules about which rows to use, I thought it would be a simple matter to bring into Access and use queries and forms to take care of the tedious parts. It took longer than I thought to set up, and am a bit burned out so it may be a simple solution that I'm not seeing. I found AutoFillNewRecord from the microsoft site.
https://support.microsoft.com/en-us...-data-from-a-previous-record-automatically-in
Added that to my module and form as instructed. It worked. Unfortunately, when I tried to use it with the combobox to find record, I get error
https://support.microsoft.com/en-us...-data-from-a-previous-record-automatically-in
Added that to my module and form as instructed. It worked. Unfortunately, when I tried to use it with the combobox to find record, I get error
I tried stepping through the code, but it didn't show me the code, went straight to the error. I couldn't see where the problem is. In the meantime, I have been manually setting the filter by clicking in a field cell using datasheet view and then clicking the Selection under Sort & Filter ribbon. Once I have finished adding records, I toggle filter to turn off, then have to remember where I was in order to locate the next record to filter. Tedious, but works.The expression On Current you entered as the event property setting produced the following error: Type mismatch.