I have a form that I am entering data into for the first time. All the data is loaded to a table. Once I add a record how can I use auto fill so if I type the same name again the data will use the name to auto fill the rest of the information? I am not sure if dlookup is what I am looking for...