Multiple Subforms

  • Thread starter Thread starter SMBR via AccessMonster.com
  • Start date Start date
S

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!!!
 
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
 
Is there a different way I should be going about
this? Any help/suggestions will be greatly appreciated.
Click to expand...

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

John W. Vinson[MVP]
 
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


Larry said:
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
Click to expand...
[quoted text clipped - 18 lines]
trying
to get passed this issue for several days. Thanks!!!
Click to expand...
Click to expand...
 
Back
Top