Pass Member ID from one for to another

R

Rob

I created a Member form that has a button that will launch a Payment form.
I cannot seem to get Access to pass the existing Mbr ID to the Mbr ID field
in the Payment form. I've done similar function with normal access database
not with MSDE and Access frontend. It seems to function differently. Does
anyone have any ideas or suggestions?
thanks
rob
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You're using the OpenArgs property, right?

Member form:
DoCmd.OpenForm "form_name", OpenArgs:=Me!Mbr_ID

Payment form On Open event procedure:

If Not IsNull(OpenArgs) Then
' ... do what you want w/ the Mbr_ID
End IF

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

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

iQA/AwUBQX/okIechKqOuFEgEQKTigCg8hxV9ztkkt5l6P6/1FcGmazWBQQAoJr0
FkIf8z1ec20rqf6/7EWRbKzO
=LWME
-----END PGP SIGNATURE-----
 

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