I'm developing an application where I am I have a data set of clients, and then complete survey processes with this set. My goal currently is to launch the survey from within the client record, so I'm doing a OpenForm command and am trying to carry the Client ID number to the form that is opening, so far without luck.

Can anyone help me with this?

Here are the two ways I pass data:

1) Push

a) You can use the OpenArgs parameter of the DoCmd.OpenForm to pass pus the data to the form it opens. When the other form opens use the Form's On Load or On Current event, depending on your app's design, to retrieve the Me.OpenArgs property and assign it to something.

b) use the DoCmd.OpenForm Where parameter to filter the data on the fomr that opens.

2) Pull

In the form that opened with DoCMd.OpenForm, use the Form's On Current or On Load event, depending on your app's design, to retire the data from the original form used a form reference to the control with the value.

Example: Me.txtSurveyClientID = Forms!Clients.txtClientID

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015