By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

the name of the Form....

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.