Copy value from form to form?

  • Thread starter Thread starter Henro
  • Start date Start date
H

Henro

I have thius form with values in fornt of me. Now I want to doubleclick a
certain value and I want THAT value to be copie to a field in another form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
 
Assuming that form Bezoek Subformulier is open when you double-click, you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me.[Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers
 
Thought it would be simple like that but now it start talking about an error
between Access and ActiveX?

Henro

Douglas J. Steele said:
Assuming that form Bezoek Subformulier is open when you double-click, you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me.[Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Henro said:
I have thius form with values in fornt of me. Now I want to doubleclick a
certain value and I want THAT value to be copie to a field in another form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
Click to expand...
Click to expand...
 
I have it working BUT the form [Bezoek Subformulier] is a subform of [Deal
related] and as such ACC2000 doesn't regard Forms![Bezoek Subformulier] as
opened?? If I open the form [Bezoek Subformulier] with DoCmd.Openform
"Bezoek Subformulier" it fills the Forms![Bezoek Subformulier]![Contract]
but it ends up in a different record. That's probably because it opens
another instance of the form. I need VB to fill it in in the Subform, not
the one I just opened. How do I do this?

Anyone any idea's?

TIA Henro


Douglas J. Steele said:
Assuming that form Bezoek Subformulier is open when you double-click, you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me.[Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Henro said:
I have thius form with values in fornt of me. Now I want to doubleclick a
certain value and I want THAT value to be copie to a field in another form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
Click to expand...
Click to expand...
 
OK, maybe I didn't read close enough, but I saw the word subform
and immediately thought of this syntax:

Forms!frmMainForm.objMySubform.Form.txtMySubformTextBox

The thing to get right is in the middle above ... .Form.

You cannot and should not open the subform by itself outside its form
container. It's already opened, of sorts, inside the main form.
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast


Henro said:
I have it working BUT the form [Bezoek Subformulier] is a subform of [Deal
related] and as such ACC2000 doesn't regard Forms![Bezoek Subformulier] as
opened?? If I open the form [Bezoek Subformulier] with DoCmd.Openform
"Bezoek Subformulier" it fills the Forms![Bezoek Subformulier]![Contract]
but it ends up in a different record. That's probably because it opens
another instance of the form. I need VB to fill it in in the Subform, not
the one I just opened. How do I do this?

Anyone any idea's?

TIA Henro


Douglas J. Steele said:
Assuming that form Bezoek Subformulier is open when you double-click, you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me.[Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Henro said:
I have thius form with values in fornt of me. Now I want to doubleclick a
certain value and I want THAT value to be copie to a field in another form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
Click to expand...
Click to expand...
Click to expand...
 
Altough the function seems to work the function fdeelnemer() stays empty :'(

What am I doing wrong? What info do you need from me to solve this?

Henro


Danny J. Lesandrini said:
OK, maybe I didn't read close enough, but I saw the word subform
and immediately thought of this syntax:

Forms!frmMainForm.objMySubform.Form.txtMySubformTextBox

The thing to get right is in the middle above ... .Form.

You cannot and should not open the subform by itself outside its form
container. It's already opened, of sorts, inside the main form.
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast


Henro said:
I have it working BUT the form [Bezoek Subformulier] is a subform of [Deal
related] and as such ACC2000 doesn't regard Forms![Bezoek Subformulier] as
opened?? If I open the form [Bezoek Subformulier] with DoCmd.Openform
"Bezoek Subformulier" it fills the Forms![Bezoek Subformulier]![Contract]
but it ends up in a different record. That's probably because it opens
another instance of the form. I need VB to fill it in in the Subform, not
the one I just opened. How do I do this?

Anyone any idea's?

TIA Henro


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> schreef in bericht
Assuming that form Bezoek Subformulier is open when you double-click, you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me.[Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have thius form with values in fornt of me. Now I want to
Click to expand...
doubleclick
a
certain value and I want THAT value to be copie to a field in another
form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
Click to expand...
Click to expand...
Click to expand...
 
When you double click on the value is it a text box or a
combo box? If it is a text box and you don't have
anything typed in the function will only show empty. If
it is a combo box and you don't have anything selected it
will show empty. Make sure to put something IsNull to
return a message box or a default value. Good luck!

-----Original Message-----
Altough the function seems to work the function fdeelnemer () stays empty :'(

What am I doing wrong? What info do you need from me to solve this?

Henro


"Danny J. Lesandrini" <[email protected]> schreef in bericht
OK, maybe I didn't read close enough, but I saw the word subform
and immediately thought of this syntax:

Forms!frmMainForm.objMySubform.Form.txtMySubformTextBox

The thing to get right is in the middle above ... .Form.

You cannot and should not open the subform by itself outside its form
container. It's already opened, of sorts, inside the main form.
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast


Henro said:
I have it working BUT the form [Bezoek Subformulier]
Click to expand...
Click to expand...
is a subform of
[Deal
related] and as such ACC2000 doesn't regard Forms!
Click to expand...
Click to expand...
[Bezoek Subformulier]
as
opened?? If I open the form [Bezoek Subformulier] with DoCmd.Openform
"Bezoek Subformulier" it fills the Forms![Bezoek Subformulier]![Contract]
but it ends up in a different record. That's probably because it opens
another instance of the form. I need VB to fill it in
Click to expand...
Click to expand...
in the Subform,
not
bericht
Click to expand...
you double-click,
you
should only need to use:

Form![Bezoek Subformulier]![Contractnummer] = Me. [Contractnummer]

in the Double Click event associated with Contractnummer on form
ContractNummers


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have thius form with values in fornt of me. Now
Click to expand...
Click to expand...
I want to
doubleclick to a field in
another
form.

How can I do this? I can't seem to find my way round the new ACC2000
helpfiles :-(

Form![ContractNummers]![Contractnummer]

should on doubleclick be filled in in

Form![Bezoek Subformulier]![Contractnummer]

Anyone knows how to do this?

Thanx for thinking with me!

Grtz Henro
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top