Populating Second Form Based on First

[lewando_bria]

Hi there...I need to produce an application that allows users to enter in a project number on one form, then click a button to bring up a second, different form that contains additional information corresponding with the project number entered on the first form...they are both based on the same table called "tblProjectList"...in the future i will probably need to populate other areas of the second form with information from a second table...but i'll deal with that when it happens ...hehe...as an example of the information that needs to pulled onto the second form one of the text box controls must contain the "Assigned to" information....thanks for any help!!!

 

[Beerbrewer]

And what does not work after you created a (linked)form based on the same table and a button to open it (and search for specific records)?

 

[lewando_bria]

I can get the values into the second form using the DLookUp function...but when this is done....the values overwrite data in the table "tblProjectList"...i need to have the information displayed, without overwriting existing data in the table...i cannot get just the one record that i am referriing to, to show up in the second form....