Form doesn't save data when a certain field is left blank - help!

[StarScream]

Form doesn't save data when a certain field is left blank - help!

Scenario: I have 2 tables. One has personnel information. Another has taskings information. The two tables are connect by a personnel field and an organization field. I created a form from a query with a mixture of fields from the two tables. The idea is that I can input the tasking information into the form and assign it an organization and/or a person (two separate fields). (I may not know who specifically to assign a tasking to, but I will know which organization to assign.)

As such, the organization field is required, but not the person field. Problem is the only unique key to both tables is the person not the organization field. If I don't input a person, it never saves the record. I get no error when I close, it just closes and never saves the info. In fact, I can leave blank any of the required fields and it won't give me an error.

Any ideas ?

PJ

 

[mailzero28]

Hi PJ,

I'm just guessing here - but are you sure the query you are using is updateable?

Run the query through Query Builder, and try and add the data manually, looking down to the bottom left of the status bar to see what it says - If it's not updateable, it will tell you there.

If this isn't the case, check the table design to see if a null value is acceptable.

bye

Martin