Open form populated with data from query and update table with cha

[Guest]

I have a form called "frmEscRef" that has a text box called "txtRefLookup".
I've created a query called "qryEscRefFind" that returns the record that
matches the reference field in my table "tblEscData".
I have a control button "cbGetRec" on "frmEscRef" that I would like to open
a new form called "EscUpdate" that will populate the fields
("txtRef","txtName","txtStatus") on the form from "qryEscRefFind".

Thanks

 

[Guest]

Combine the three values into a single string, separating them with a pipe
character ( | ). Use the combined string as "OpenArgs" when opening the
form. In the "OnLoad" procedure, separate the string back into individual
values and use them to populate the fields on your form.

Bruce

 

[Guest]

What would that look like?

Combine the three values into a single string, separating them with a pipe
character ( | ). Use the combined string as "OpenArgs" when opening the
form. In the "OnLoad" procedure, separate the string back into individual
values and use them to populate the fields on your form.

Bruce