Search results

Can the code in the earlier thread be modified to compare text and error duplicates? Thanks, Ian

Thanks for the direction. But I'm not quite getting this to work. Here is the code: Private Sub Combo58_Change() If Me.[Sales Phase] = "5" Then Me.[Install Date].Visible = True Me.[Install Date].Enabled = True Me.[Install Date].SetFocus Else If Me.[Sales Phase] <> "5" Then...

Is it possible, with the selection of a entry in a drop list, to change the requirement of another field. What I'm trying to do is, in a "Probability of Close" combo list, if 100% is selected from the choices, to make the "Install Date" field required. Otherwise, this field isn't even visible...

That got it, thanks. One thing that I hadn't been doing with this subform table is populating the master record number. I did that in addition to your suggestion to force a one-to-many relationship and it worked like a charm. Thanks again for pointing me in the right direction. Ian

If they need it for training purposes, just run a screen shot.

I am creating a CRM Database, and have embedded an Activity History subform in the main customer entry form. My problem is this: when populating activity history in the first Main Customer entry form, the same information in the activity history populates through all Main Entry forms'...