That sounds like it would work

I Estimate for a commercial wood working firm

I use Access to track my jobs and generate Bids

For example I might bid a hotel and need to exclude 300 wood doors and
frames.

So that would go into me exclusion field

I need to make sure that the exclusion is attached to the right job

This all works on a form with a sub form, the main form is information
about the job being bid, Name address and so on the sub form is where the
information is entered about the bid.

If I were to put the exclusion in with the wrong job thin I would be in
major trouble

If it is on the plans and you don’t exclude it then you have to provide it

I wouldn’t want to have to provide 300 doors and frames that I didn’t have
money in the bed for.

All that to say I need to make sure everything about the bid is with the
right job.

Could I set the buttons where every time I change to a new record on the
main form that I would have to reactivate the form before I enter data

Any other ideas would be helpful

Thanks for you help