Data Entry form problems

[allie357]

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.

 

[John Vinson]

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]