Hi all, My new job involves entering data into tables and I have full encouragement to try and speed up the process. I'm not allowed to say exactly what I am doing, but the gist of it is: Open excel doc with location data + inspection data in. Open access form with a drop down menu giving the name of location data has come from open acces table with data about the location (e.g. id numbers, etc) enter id numbers etc into form + location data + inspection data. now there is a lot of data that is the same on each form of the same place (e.g. id numbers), so lots of repeating info. Ideally the table with the data is linked to the form thing, so when i choose the location from the drop down list on the form, access automatically fills in the rest of the data that is linked to this location. the big question is: How on earth do I do this? I'm not that familiar with Access, and the help file isn't particularly helpful. Thanks for any help in advance! Profqwerty
Your question is not clear for me but you can post your question to this forum where there are many guys that are experts in Access http://www.mrexcel.com/board2/viewforum.php?f=14
