Yes, I should have given a few more details about the Airport table and yes it was a typo. In case there is a neater answer, the Airport table is:
ID: Autonumber
APCity: Text
APName: Text
Country: Number (pointer to a country table)
APCode: Text
APLat: Number (Double)
APLong: Number (Double)
The Coutry table has just got an ID (autonumber) and a Text field
I realize the I'm setting APLat and APLong to "" in the second SELECT, but this is because the second SELECT is just adding the option to add a new Airport and I don't want any other information presented, including 0.0's; it seems to work.
Thanks
Dave