470,638 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

the name of the Form....

Ray
I have a main form with four subforms.

Let's imagine that the subforms are named Form1, Form2, Form3 and
Form4.

From any of the subforms I would like to doubleclick to open another
form "frmGuests" in which I would like to enter then name of the form
Form1 or Form2 etc as the default in a field in a subform
"frmReservation" of the newly opened form. Can anyone tell me if this
is possible?

Thanks

Ray
Nov 12 '05 #1
1 1483
Ray wrote:
I have a main form with four subforms.

Let's imagine that the subforms are named Form1, Form2, Form3 and
Form4.

From any of the subforms I would like to doubleclick to open another
form "frmGuests" in which I would like to enter then name of the form
Form1 or Form2 etc as the default in a field in a subform
"frmReservation" of the newly opened form. Can anyone tell me if this
is possible?

Thanks

Ray

(air code)
In the sub form)
Sub Form_DblClick()
' check which parameter is Openargs, the tooltip will tell ya.
DoCmd.OpenForm "frmGuests",,,,,,me.name
End Sub

In frmGuests
Sub Form_BeforeInsert(Cancel As Integer)
Me!MyFormNameField = Me.OpenArgs
End Sub

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by CJ | last post: by
3 posts views Thread by Scott Navarre | last post: by
7 posts views Thread by Christopher J. Hahn | last post: by
11 posts views Thread by Ahmet AKGUN | last post: by
14 posts views Thread by Altman | last post: by
reply views Thread by Greg | last post: by
24 posts views Thread by Chameleon | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.