Transferring Data from one form to another

[sgreenman]

I am having a problem getting the information i entered in one form to transfer over to another. I want to take the data entered in specific fields and auto fill them into another form i open using DoCmd.OpenForm. Any help would be greatly appreciated. Below is a snippet of the VBA code i am trying to use. I am green when it comes to VBA and Access so i am probably doing this completely wrong.

Code used:

Dim ID As Long

DoCmd.OpenForm "JobLogForm"



DoCmd.GoToRecord , , acNewRec

ID = DMax("JobID", "JobList")
JobIDCopy = ID
JobLogRecDate = Dlookup("JobRec", "JobList", "JobID=" & ID)
JobLogDueDate = Dlookup("JobDueBy", "JobList", "JobID=" & ID)
JobLogDes = Dlookup("JobDes", "JobList", "JobID=" & ID)

[pbaldy]

Along the lines of:

Forms!JobLogForm.TexboxName = JobIDCopy

[Gicu]

You don't need to replicate the last three fields as it goes against good relationship database design, you just need to store the newly created JobID and you can get the rest anytime you need in a query by joining this table to JobList by ID to JobID.

Cheers,

[sgreenman]

Thanks for the tips ill try and figure it out as i said i am new to access and i am still figuring out how the relationships work.

[June7]

Maybe you need a form/subform arrangement.

Main form bound to JobList and subform bound to JobLog.

JobID will automatically populate into new record of subform.