Automatically loading data into fields in a form.

[Dreamcatcher]

Hi,

I writing a database to record all correspondance with customers.
I've set up a CUSTOMERS table containing info like Client_Ref, Client_Name, Company_Name etc.

Now from the main operator screen i've got a 'Create New Record' button which at the moment runs an [Input]=[Client Ref] condition alllowing the operator to input a Client_Ref number....
From there i want it to open a New_Record Form with the Client_Ref, Client_Name, Company_Name etc automaically inserted into the relevant fields in the New_Record Form (pulled from the CUSTOMERS table). Operator would then fill in the remaining field and the save the info onto a RECORDS table.

How do i get the the Client_Ref, Client_Name, Company_Name etc to be automaically inserted into the relevant fields in the New_Record Form??

Or is there a better way of doing this?

All help would be appreciated as my head is beginning to hurt now.

 

[khawar]

File you attached is blank and contain no objects

 

[Dreamcatcher]

Correct one attached now

 

[AirForceCoder]

you could use user id which would be set up as a key field in a table then use a query or recordset to retreive the newest data inserted in the fields and the populate the fields right?

so some thing like

populate_click()
dim frm as form
docmd.openform "name of form"
with frm
.formfields("name of text box").result = rst!name of field
...
end sub

that should fill in the boxes with the most resent data if i am correct