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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating a value from a subform to the main form 1
Form not Pre-Populating Correctly 3
populate form with a recordset 3
Update multiple record values from form/query 1
Data entry for a table from a form 1
Adding records to table from a form, with pre-populated values 5
Access Click in Table to Open Form 0
On Click, Open a form, choose a selection then have it populate fi 8

Back
Top