- Joined
- May 23, 2017
- Messages
- 1
- Reaction score
- 0
Hi all, this is my first post, and please be warned, I am no wiz on coding! I have an MS Access dbase. Three fields in one of the tables are for 'LATITUDE' (sample data in this field is -29 27 36.00), LONGITUDE' (sample data in this field is 115 00 57.90) and 'LATLONGWITHDEGMINSEC' (which is blank). I would like a bit of vba code to place in the AfterUpdate property for each of the LATITUDE and LONGITUDE fields so that as each of those two fields are updated, the LATLONGWITHDEGMINSEC field is automatically filled to exactly show 29°27'36.00"S 115° 0'57.90"E.
Any and all help would be very much appreciated, many kind thanks!!
Any and all help would be very much appreciated, many kind thanks!!