Passing field from one form to another

G

Guest

- I have form with 4 fields (field1, field2, field3, field4)
- The input for these fields MUST come from a table. The user can enter
text or...I have created a pop-up form to look up values.
- I have it working so that when the user clicks a button next to field1,
the pop-up will 'jump' to the value of field1 (if it is filled--otherwise it
goes to the first value)
- I would like to have the user be able to select a field on the pop-up form
and then click a button and send that value to the original form in field1
(or 2, etc..)

I have set an unbound text box called 'fieldnumber' to 1,2,3 or 4 depending
on which button on the main form is pressed. I even have the 'accept' button
on the pop-up displayed as 'Accept for field[fieldnumber]'

Now I need a way to pass the selected item on the pop-up back to the correct
place.

Any ideas...
 
G

Guest

I found this...
Dim strControlName As String
strControlName = "City"
Me(strControlName) = "New York"



sorry...sometimes finding the answer is difficult when you don't know how to
ask the question in the search box....
 

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

Top