I have a Policy Violations database that someone else built and I have
had to normalize.
Now I am having trouble building the new entry form. I know I will
probably need a subform or a button that opens a subform to add a new
violator. What I wanted to do was have a combo box that would
facilitate data entry for new violations for repeat offenders. I have a
Violators table in a one to many relationship with a Violations table
and there are violators with multiple violations. I want to be able to
use the combo box to add the violator's name to the new violation. I am
using Violator_ID, the foreign key for the combo box on the form.

I have data entry set to yes but it does not seem to like me adding new
records to the table.

Any help is appreciated or design advice.

On 31 Aug 2006 11:25:06 -0700, "allie357" <(E-Mail Removed)>
wrote:

>I have a Policy Violations database that someone else built and I have
>had to normalize.
>Now I am having trouble building the new entry form. I know I will
>probably need a subform or a button that opens a subform to add a new
>violator. What I wanted to do was have a combo box that would
>facilitate data entry for new violations for repeat offenders. I have a
>Violators table in a one to many relationship with a Violations table
>and there are violators with multiple violations. I want to be able to
>use the combo box to add the violator's name to the new violation. I am
>using Violator_ID, the foreign key for the combo box on the form.
>

What you'll probably want is to have a Combo Box on the Violations
subform, bound to the ViolatorID field, and based on the Violators
table; and use VBA code in that combo box's Not In List event to pop
open a new form to enter the violator's information when a new
violator must be added.


John W. Vinson[MVP]