Hello,
I am sure there must be an easy answer to this but I cannot seem top make it work. Can someone please offer any guidance.
I am importing data into access database from an excel worksheet, The data imports fine with no errors shown.
When I open a form in the database the data is shown correctly, however an after update event that I have added to the cell does not fire, I have pressed refresh, closed, opened the worksheet and database, imported it in various formats including csv, excel 97, xlsx, I have tried adding a coma, removing a coma, formatting the cells whilst the data is still in excel but still the database does not recognise the data in the textbox to carry out the after update function.
If I click in the cell where the data is, add a space, or coma the "After update" will fire, it will also fire without a problem if I just cut and past the text in to the textbox, I have checked the If Me and tried = and Like but it will not fire until I click in the cell.
Can someone please offer some guidance as to what is happening.#
many thanks