Help with matching data

[avenger619]

Hi guys,

I could use the help, I have included a data sample of what am trying to do.

On my main form I have basic client info, then on the side a check mark for additional services along with a command "+" to open another form so the rep can log in additional information. Unfortunately I cant get that additional form to reference the main applicant, so the data that is being logged in coincides with his.

Im sure this is probably a simple thing, but I have hit a wall :banghead: on this one.

 

[Isskint]

Just add the WHERE argument of the OpenForm method to open the form at the current applicant.


stDocName = "Service1Info"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Becomes

stDocName = "Service1Info"
stLinkCriteria = "([Applicant]='" & Me.Applicant & "'")
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[avenger619]

Thanks Isskint

I will give it a try in the morning to see if it works.

One more question, technically it should save the data automatically once the form is closed right? or Should I add a save code to the close event too?

 

[Isskint]

No need for save code. The data will be saved as you close the form.