Adding Info from Two Forms to One Table

[Bravoflight]

I have a Form that pops up another form, Depending on the response from one of the Fields. Both forms add records to the same table.

ex. Table Fields

Test1; Test2; Test3;

Form1 Fields

Test1; Test2

Form2 Fields

Test3

My hang up is I want the info from both forms on the same record.

Thanks, for any help on this Topic

 

[chrismcbride]

The only reason I can think of to have two forms is that all the controls will not fit onto one. If this is not the case, then put all the controls on the one and hide the ones you don't need until the control that defines if they are needed is updated.

If you do need two forms, then make them both bound to the same table and include the PK in both forms. Once the user has entered a value that indicates that the second form should be opened, open it and pass the PK as a open criteria. Be sure to close the first form behind you as there may be record locking issues.

HTH
Chris

 

[Bravoflight]

Thanks Chris, I'm going to hide the controls on the form and make them active when necessary.