Multiple Subforms

[SMBR via AccessMonster.com]

I have a database that holds job information for a Mechanical Contractor. I
have a main form linked to T_JobInfo that contains the job number and job
name. I have a subform linked to T_BidResults that enables the user to record
the bid results for each project. There is usually several bid results for
each project. I would like to be able to enter multiple subforms onto the
main form to allow the user to enter more than one bid results at a time. I
tried using the same subform and adding it to the main form several times. I
have also tried copying the subform, renaming each as a different subform and
adding them to the main form that way. Each time, I end up with the same
result. Whichever bid result I enter into the first subform copies into each
of the additional subforms. Is there a different way I should be going about
this? Any help/suggestions will be greatly appreciated. I have been trying
to get passed this issue for several days. Thanks!!!

 

[Larry Linson]

Describe your Tables and we'll have a better shot at making a useful
recommendation. Access is _Table-based_ not _Form-based_.

Larry Linson
Microsoft Access MVP

 

[John Vinson]

Is there a different way I should be going about
this? Any help/suggestions will be greatly appreciated.

Yes; use a Continuous Form for the subform, rather than multiple
subforms.

John W. Vinson[MVP]

 

[SMBR via AccessMonster.com]

T_JobInfo
Job Number (autonumber)
Job Name
Bid Date
Estimator ID
Contract Type ID
Work Type ID

T_BidResults
Bid ID
Job Number
Contractor
Base Bid
Alternate #1
Alternate #2
Alternate #3
Alternate #4

Describe your Tables and we'll have a better shot at making a useful
recommendation. Access is _Table-based_ not _Form-based_.

Larry Linson
Microsoft Access MVP

I have a database that holds job information for a Mechanical Contractor.
I

[quoted text clipped - 18 lines]

trying
to get passed this issue for several days. Thanks!!!