Mass Append From Form

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am using Access 2002 on a Windows XP machine.

Basically, even though I know it is bad structure, I have 3
fields in about 5 tables each (I didn't create this
database, I inherited it and they DO NOT want anything
changed, just this feature added). To enter a new record
now, they have to put the same three things in all the tables.

What I was thinking is that I would create a form that had
the three fields on it and they would type in the
information, hit a button and a query would run that would
place the info in all tables.

I tried this in SQL using this statement:

INSERT INTO [*tblMaster] ( [Agency#] )
VALUES (Forms!frmEnterNewAgency!AgencyID);

It worked when I would just run it and type in the
criteria, but when I have the form open and info in the
form, I get an error saying it cannot run due to validation
rules. The thing is, in the table I have no validation rules.

The text boxes on the form are unbound, and the field on
the table is a double.

Any help would be great!

-Mike
 
Mike

Validation rules may include things like required fields, and no duplicate
indexes, and ... and any of the other field properties that constrain what
can be entered. They are not simply what's put in the Validation Rule
property.

?Confusing?!
 
Back
Top