Dear All,

I am somewhat new to Access 2000.

Basically I have one form with various details that a user enters. At the end of that form there is a button that takes you to another form. I would like the details of for example, name and date of birth that have been entered to be taken to the new form auomatically. Do I do this with a sub-form ? and if so how ? or is there another way ?

Best Regards,

Anthony

Change the recordsource of the subform to join to the main table. That way all the columns you need will be available. Be sure to set the properties for these fields to enabled = no and locked = yes to prevent edits from the subform.