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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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...
 
Back
Top