field must be filled when a choice is made from combo box

[Tom Tripicchio]

In my database I have fields called ID#, date, and category. An ID# can
have multiple dates and 5 different categories per ID#. The categories are
tied to a combo box. What I would like to do is add another field called
explanation and this field would have to be filled in when certain
categories have been selected. How do I go about this?

Thanks, Tom

 

[Emilia Maxim]

In my database I have fields called ID#, date, and category. An ID# can
have multiple dates and 5 different categories per ID#. The categories are
tied to a combo box. What I would like to do is add another field called
explanation and this field would have to be filled in when certain
categories have been selected. How do I go about this?

Tom,

where are those fields, in different tables (should be 3) or in the
same (would be totally wrong)? And how should be the new field
handled, i.e. the content of the same one field change when categories
are choosen, or a new entry should be created each time categories are
choosen? Would be this new field related to the ID# (i.e. one such
field for one ID#), or related to the date?

And how's your form looking, is it some main form/subform construct?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de