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

Q

Qaspec

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
 
B

BruceS

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
 
Q

Qaspec

What would that look like?

BruceS said:
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
Click to expand...
 
Top