Hi all, not having a god day today
I decided that I wanted to write my payroll data to a temporary file first, so that any amendments could be made and then copy to final payroll file that would never get amended.
So I decided to put in a combo box with two options and change the record source accordingly.
Attached is a db that I exported the forms and tables to.
Basically it worked once and then no matter what I selected, I got a blank table. I even changed the record source in properties to "tblEmployee" which has no matching fields and it did not complain?
I then created a test form and that works?
Obviously I can recreate the form, fortunately there is not much on it, or code behind it, but what have I done to get in this situation?, so that I do not do this again?
I have tried a compact and repair, with no luck.