In Microsoft Access 2000, I have a form that is for adding a new record and contains 2 subforms that each link to different tables. The subforms are connected by a user ID. I do not want the user to type his user ID twice, so when the user types his user ID in the first subform I want it to also show up in the user field in the second subform. I have tried the following event procedure:
Me![User_ID]=[forms]![add education info]![User_ID].

However, this code does not work and the computer tells me that is cannto find the form add education info. The name is spelled correctly and I do not know why this isn't working or if there is a better way. :mad: