WhereCondition newrecord

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with successive pop-up forms opened by command buttons
that use the docmd.openform command with the Wherecondition set to "[MainID]
= me.mainID".
Each of the pop-up forms opens correctly if there is an existing record.
However, if the child table doesn't have a record yet, how can I ?
A) check to see if there is a record (newrecord isn't set to yes when the
blank form is opened)
and
B) set the hidden textbox containing the Key [mainID] to the value of the
parent

Cheers,

Gordzilla
 
Gordzilla said:
I have a main form with successive pop-up forms opened by command
buttons that use the docmd.openform command with the Wherecondition
set to "[MainID] = me.mainID".
Each of the pop-up forms opens correctly if there is an existing
record. However, if the child table doesn't have a record yet, how
can I ?
A) check to see if there is a record (newrecord isn't set to yes when
the blank form is opened)
and
B) set the hidden textbox containing the Key [mainID] to the value of
the parent

Cheers,

Gordzilla
Click to expand...

If the pop-up forms will only be used when the main form is opened just set
the default value property to something like...

=Forms!MainFormName!mainID
 
Thanks
That worked. I originally had that but was getting a runtime error whenever
I tried to save the record.
Turns out I had a text box on one of the forms that was bound to a field
that it shouldn't have been.

Gordzilla

Rick Brandt said:
Gordzilla said:
I have a main form with successive pop-up forms opened by command
buttons that use the docmd.openform command with the Wherecondition
set to "[MainID] = me.mainID".
Each of the pop-up forms opens correctly if there is an existing
record. However, if the child table doesn't have a record yet, how
can I ?
A) check to see if there is a record (newrecord isn't set to yes when
the blank form is opened)
and
B) set the hidden textbox containing the Key [mainID] to the value of
the parent

Cheers,

Gordzilla
Click to expand...

If the pop-up forms will only be used when the main form is opened just set
the default value property to something like...

=Forms!MainFormName!mainID
Click to expand...
 
Back
Top