Need automatic entry into certain field of form. (1 Viewer)

[kgcrowther]

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

 

[Jack Cowley]

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

 

[kgcrowther]

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.

 

[kgcrowther]

I figured it out. Thanks for your help!!