New record with data from other form

On Tue, 15 Feb 2005 14:46:29 +0100, "proo" <patrick.DeleteThis@industrienet.nl>
wrote:

 >I would like to open a addrecord form. In this form I would like teh Field
 >DebNr to be filled with the value of the field DebNr in my (open) form
 >FrmStam.
 >
 >I used the VisualBasic code ;
 >
 >Private Sub Form_Open(Cancel As Integer)
 >
 > If IsOpen("FrmStam") Then
 > DebNr.DefaultValue = _
 > Forms!FrmStam!DebNr
 > End If
 >
 >End Sub
 >
 >After running this code the value of the field DebNr in the Addrecord form
 >is [#Naam?] . In Englisch [#Name?]
 >
 >Where do I go wrong ?

Apparently, MS Access cannot find a field named "DebNr" in the
Forms!FrmStam form.

If the field is already bound, if it already has a "Control Source",
then the code should be unnecessary. Right click on it, select
properties. Click on the Data tab. (I created a screenshot in English
MS Access '97, but binary attachments aren't allowed on my server.)

What version of MS Access are you using?
_______________________
Michael B. Johnson<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: New record with data from other form 

proo wrote:

 > I would like to open a addrecord form. In this form I would like teh Field
 > DebNr to be filled with the value of the field DebNr in my (open) form
 > FrmStam.
 >
 > I used the VisualBasic code ;
 >
 > Private Sub Form_Open(Cancel As Integer)
 >
 > If IsOpen("FrmStam") Then
 > DebNr.DefaultValue = _
 > Forms!FrmStam!DebNr
 > End If
 >
 > End Sub
 >
 > After running this code the value of the field DebNr in the Addrecord form
 > is [#Naam?] . In Englisch [#Name?]
 >
 > Where do I go wrong ?

Set a breakpoint (F9) on the 'debnr.defaultvalue' line.

Run the program. When the program pauses at the
breakpoint, put the mouse pointer over
'Forms!FrmStam!DebNr'. A tooltip should pop up with
the current value in 'Forms!FrmStam!DebNr'.

Is DebNr the name of a label instead of the intended
textbox, by any chance?<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: New record with data from other form 

"Randy Day" <ruthal RemoveThis @sasktel.nex> schreef in bericht
news:11146l1nvhp0td2@corp.supernews.com...
 > proo wrote:
 >
  >> I would like to open a addrecord form. In this form I would like teh
  >> Field DebNr to be filled with the value of the field DebNr in my (open)
  >> form FrmStam.
  >>
  >> I used the VisualBasic code ;
  >>
  >> Private Sub Form_Open(Cancel As Integer)
  >>
  >> If IsOpen("FrmStam") Then
  >> DebNr.DefaultValue = _
  >> Forms!FrmStam!DebNr
  >> End If
  >>
  >> End Sub
  >>
  >> After running this code the value of the field DebNr in the Addrecord
  >> form is [#Naam?] . In Englisch [#Name?]
  >>
  >> Where do I go wrong ?
 >
 > Set a breakpoint (F9) on the 'debnr.defaultvalue' line.
 >
 > Run the program. When the program pauses at the
 > breakpoint, put the mouse pointer over
 > 'Forms!FrmStam!DebNr'. A tooltip should pop up with
 > the current value in 'Forms!FrmStam!DebNr'.
 >
 > Is DebNr the name of a label instead of the intended
 > textbox, by any chance?

Thanks for the suggestions.
Unfortunately it's not yet solved.

When running a breakpont the results are ;
DebNr.DefaultValue = ""
Forms!FrmStam!DebNr = "01AAA01" ; This is as it should be.

I have also changed the textfield in DebiteurNr, which gave an error in my
vb-code. After changing the code the form opened with the same error.

Any further suggestions are more then welcome.

Thanks again.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: New record with data from other form