empty field

[amber mara]

How can i manage to avoid save a record if one field is empty or null in Access ? I need to save the record with the price saved....it cannot be saved if the price fields are empty or null. Is there anyone who could give me a hand on this?

[ConneXionLost]

Hi Amber,

Go to the relevent table in design view. Select the field, and change the "Required" property to "Yes".

Cheers,

[amber mara]

I have a subform based on a query where the table with this 2 numerical fields PC and PV are empty. The values for these fields are in another 2 tables, one for PC other for PV and the table must be completo with the replacement of this 2 fields by the values extrated from the PC and PV tables. I must bring in the prices before user saves the record. As the table in the query has not values in these fields, i cannot change the property to required. My problem is deal with the fact that the record cannot be saved unless the 2 fields PC and PV have values on them. if they dont, record cannot be saved at all without price. I have the fields displayied in the sub form and must make sistem bring the price from the tables putthem in the correct fields that are empty and only if there is prices on them, save the hole table.