Entering info from two forms into one table. 2

[netrusher]

I currently have a form with some check boxes. When I check
the PPEEyeProResults check box it opens another form
so I can input further data. The other form is bound to
the same table as the first form. The issue is when I enter
information on the pop-up form it puts the info in the
table as another record and not the same record as the
info from the first form. Should I be putting information
from two forms into the same table? If that is ok, how do
I ensure the information I am entering from the pop-up form
is going to the same record as the information from the
first form?

 

[PHV]

Have a look at the 4th parameter of the DoCmd.OpenForm method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

PH, thanks for the answer. Below is the code that I have
but I think I do not totally understand so I am hoping you
can help some more.

If Me.PPEEyeProResults = True Then
  
    DoCmd.OpenForm "ObserversMainTblFrm", , , "Categories = '" & Me.Categories & "'"
    
End If

The 2nd form that I am opening from the First Form is ObserversMainTblFrm.
On this second form I am wanting to input further data in the following fields.
Categories
Behaviors
UnsafeDescription
Comments
The above fields are all part of the same table where data
is being input on the first form. When I use the code like
I have it above I still get data in the table for two
different records so I know I have some other issue. Please
advise and thanks!

 

[PHV]

What is the PrimaryKey of the table ?
Hopefully: Categories ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya netrusher . . .

Why not [blue]hide[/blue] the secondary fields on the source form and [blue]show/hide via PPEEyeProResults?[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[netrusher]

PH,

The Primary Key is FormNbr which is an Autonumber.

 

[netrusher]

Aceman,

I will give your suggestion a try too.

 

[PHV]

If Me.PPEEyeProResults = True Then
Me.Dirty = False
DoCmd.OpenForm "ObserversMainTblFrm", , , "FormNbr=" & Me!FormNbr
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks PH,

I will give that a try.