Search results

Dick7Access, I am not sure whether this is the point, but in my opinion Form is not a Recordset itself and does not contain any value in [Form]![City], it only reflects the data in the underlying table or query which is linked to the particular field. So, you either indicate [TABLENAME]![City]...

AC5FF, may I ask how the report on the stored and aggregated data will look like? Do you need to preserve the same structure Excel represents or transform it into something bigger/lesser? Because if you will break the tables with manually-input data into small bits you may find yourself some...

Sometimes it helps if you indicate Null AND "" criteria. Also, have you tried to assign macro with same function to the button? Btw, i don't see any point in doing additional ApplyFilter here since OpenForm command has both Filter and WHERE condition as arguments like this: Private Sub...