cascading combobox and validation rule violation

[AndycompanyZ]

I have also put this on a nother forum but thought I'd hopefully find an answer here as well. I have a form with a couple odf cascading comboboxes on (cmboVenue and cmboVenueRoom). I can't get them to save to the table using a very simple query:

INSERT INTO tblEvent ( VenueRoom )
VALUES (Forms![frmEvent]![cmboVenueRoom]);

It runs the query and says I can't update due to Validation rule violations. The structure of the table that the second combobox is based on is


PK VenueRoomID (autonumber)
VenueRoom (Text)
FK VenueID (number) (linked to the tblVenue that gives the output for the 1st combobox)
There are no required fields in the table and all other usual vaildation violations have been looked for. I have been told its because of the PK and I can't save it inot the tblEvent because of this. I have tried using the venueroom as the bound column in the combobox properties and changing the tblevent to a text field but this also gives the same violation. Can anyone suggest a way around this as i have been working on this for days and getting no where. It is almost the last part of the db problems I have and would be extremely grateful for any advice thanks.

[boblarson]

What are the fields in tblEvent and their datatypes and do you have any of them set to REQUIRED = YES?

[AndycompanyZ]

The field it is going into is:
FieldSize: Long Integer
Decimal Places: Auto
Required: No
Indexed: Yes (Duplicates OK)
Text Align: General

Do you mean all the fields in the table? Because yes some will be required as they are behind another form which the user will be required to input some data.

[AndycompanyZ]

I've just checked and there are 2 such fields.

[boblarson]

I've just checked and there are 2 such fields.

That would be your problem. If you aren't supplying those then the query will fail. Remove the required property from the field at table level and then handle it in their form in the form's Before Update event.

[AndycompanyZ]

I did that and yes the query now runs but doesn't do what i thought. It is adding a new event but nothing in the field I wanted just a new record to the bottom so its the wrong kind of query isn't it I need an update query not an append don't I. I get very confused with the 2 queries

[AndycompanyZ]

Sorted it out now thanks a lot. Is ther anywhere I can put solved.

[boblarson]

Sorted it out now thanks a lot. Is ther anywhere I can put solved.

Yes, go up to the top under Thread Tools and select it like this: