This is a very beginner question but I would really appreciate any help I 

could get.  In my Access 2000 database I have 2 tables and would like to 

have 2 fields (proj_id and description) be automatically filled into the 

second table so that the user doesn?t need to retype the information.  In 

both tables the proj_id will be the primary key.  I would think there is 

some simple VB code or a Macro that would do this but I have been able to 

figure it out yet.



Thanks,

Pat

Pat -



This is accomplished by using Dlookup function. You can find the syntax 

for it in Access's Help.  I use it all the time for pre-filling fields 

after another value has been entered.



Regards,

Pam

It sounds like you want to take a good look at the design of your

database. There is rarely a good reason for having the same data (except

for the primary key) in multiple tables. It can retrieved when you need

it through the use of queries. 



>This is a very beginner question but I would really appreciate any help

I 

could get.  In my Access 2000 database I have 2 tables and would like to



have 2 fields (proj_id and description) be automatically filled into the



second table so that the user doesn't need to retype the information.

In 

both tables the proj_id will be the primary key.  I would think there is



some simple VB code or a Macro that would do this but I have been able

to 

figure it out yet.<



Richard Lobel