I am trying to make it less labor intensive to bill out job that my company completes. A job has differnet location on it and differnt work functions are performed at each work location. We bill out jobs based on the work functions that are performed at the various locations. I have a subform that i use to do the billing for each function. I was wondering how i could have access look at the previous record and put the location info in the new records location field. This would make it alot easier to bill due to the lack of computer skills that the people using the database have. Thank you in advance.