Required field

[BB]

I am getting the following message when entering data in a rental form. I get the message when I enter the VehicleNumber(combobox). The PickupDate is further down on the form and yes it is required. It will allow me to continue entering.

"The field tblRental.PickupDate cannot contain a NULL value because the required property for this field is set to true. Enter a value in this field."

Thanks

 

[ScottSisk]

Go to the properties of the table, and click on the field PickUpDate. At the bottom of the screen is an option that says "Required". Change it to "No" and save the table.

 

[BB]

Sorry that I didn't mention that I do want it required.

Thanks

 

[jwindon]

The trouble sounds more to be in the order of which you are entering data.

Is the form a new record when this error occurs?

I think the trouble lies with the combo box. What is the datasource for the combo? Is it bound to a field or unbound?

 

[David R]

I used to ram into this problem because I had a bunch of required fields, and some were below a subform. When I tried to tab into the subform, it tried to save the mainform and informed me unceremoniously that I had NOT filled in all the required fields. I solved it by rearranging the main form so that all the required fields were above the subform.