I'm an intern who is very new to access and even newer to VB.

I have created a form to enter main project information and then created a form to imput specific engineers information for the project. For one project there will be many engineers with similar information, but not the same.

I would like to have the information from the last entry (except project number and engineers name) appear on the form and then simple changes can be made rather than re-entering the data several times for each project.

I've played with setting the before update part with a command like 'Set field = table!table_name!table_field' but I just have no idea what code is needed.

Any help is appreciated.

Kenneth

The article below will show you how to do this. This article is for Access2000. If you have Access97 then search the Knowledge Base for Article Q136127.
http://support.microsoft.com/support/kb/articles/Q210/2/36.ASP?LN=EN-US&SD=gn&FR=0&qry=Fill%20record%20with%20data%20from%20previous% 20record&rnk=10&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2 000

This article was exactly what I needed. It fills in all the fields except those that are combo boxes. Do you know why this might be?

Thank you so much for your help.

I figured it out. Thanks for your help!!