Recent content by AndrewWhitelaw

Found my mistake. I have using a table as a subform datasheet. I created a form of the table and added that as a subform. Accessing the selected record is available through a mouseup event on the subform using me.currentrecord. I shall go stand in the corner now for being stupid.

My best advice is to create a query then view it using SQL View. You can run the sql command as a string from within vba using DoCmd.RunSQL DoCmd.RunSQL ("DELETE tempPerson.* FROM tempPerson") or you can build and SQL string and execute it, this allows some very complex queries to be built...

I am developing a database to handle gift aid for a charity. I have a donor selection form that comprises combos boxes allowing the selection of postcode, name, house number. As the user selects data in a combo a subform show as a list of potential donors from the database, as the user selects...