same subform used multiple times on one form

[SMBR]

This may be ridiculous, but this is what I am trying to do. I have 2 tables
Job Info:
Job Name
Job Number (autonumber)
Bid Date
Estimator ID
Contract Type ID
Work Type ID
Bid ID

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

I have them set up as a many to one relationship (each job can have several bid results). I am using a query for the main form to prompt the user to enter the job number for the bid results they want to enter. I have a subform set up to record bid results, but have the subform on the main form about 5 times to make it easier to enter multiple bid results. Each time I enter bid results in the first subform it copies all info to additional subforms. What am I doing wrong?

Thanks for any help!!!

 

[SMBR]

Sorry - wrong forum

 

[PHV]

Seems that your continuous subform use unbound controls or that you have 5 times the same bound controls ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886