Passing control value to form

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

Guest

I have a form where a user can scroll through a list box. When the user
selects a record in this list box, the details section of the form displays
the rest of the record. Once a user has selected the record they want, there
is a button I want the user to use to open another form, which displays the
record information from the first form.

The user will then enter some more data and then press another button to
pass the second form's data to an email recipient.

What is the best way to go about this?

tia,
 
DoCmd.OpenForm "SecondFormName",,,"ID =" & Me.txtID

Where ID is the field value in the ID control on the second form, and txtID
is the name of the textbox holding the ID value on the first form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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

How to pass multiple arguments to a second form. 3
Query Parameter using multiple options 0
Update queries with form (trying to avoid error) 1
Access Sub form opens before the main form in MS Access 0
How to stop records scrolling in bound form 2
Option Buttons to Pass Criteria to Query 6
continuous forms 3
Select record to display in form 3

Back
Top