I have two forms..one contains all info. of employess and another that records their absent date and type...in the second form when i input the ss# i want all the data i.e name address etc imported from the employee form/table..How do i do that witha macro...
Thank you

You don't need to (and should not) duplicate the name, address, etc. in the Absence table. To get this information to show on the form, change the form's recordsource to a query that joins the employee table to the absence table. You will then have all the fields from the employee table available for display on your absence form. Be sure to set the locked property to yes for each of them since this data should not be updateable on the absence form.