OpenArgs

  • Thread starter Thread starter PLWS
  • Start date Start date
P

PLWS

I have two forms. The first form is used to place an
order. When you press the command button to add an
order, using ADO, the Orders table is opened and a new
record is added. The Order ID (auto numbering) from the
Orders table is returned to a disabled text box in the
first form. The second form (a continuous form) then
opens so the user may type the items they wish to order.
1. Using the OpenArgs method, how do I retrieve the
customer's name from form 1 so that it appears in a
textbox in form 2?
2. How do I display the OrderID in the OrderID control
of form 2 for all ordered items?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Why don't you make the OrderDetail form a subform of the first form
(Order form)? Then you can link the main form's CustomerID to the
subform and keep the OrderID on the Order main form. See the Access
example database Northwind for examples of how to do this. Northwind
should have been installed when you do a full installation of Access
(Office).


--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQImWcoechKqOuFEgEQIJqwCeJT2Rps/84cchdxyy3eIwXzaXHogAoOUC
witgtaX1Hl/U1SHnOuaNhLuP
=8r68
-----END PGP SIGNATURE-----
 
P> 1. Using the OpenArgs method, how do I retrieve the
P> customer's name from form 1 so that it appears in a
P> textbox in form 2?

without openargs:

form2textbox = forms!form1!customername

same for orderid.

Vadim
 
Back
Top