Adding Empty Textbox to table

[durdle]

Hello,

I am using a SQL statement to add a record to a table. But when I leaving one field blank it will not add this record. I don't want to restrict the user from not putting anything in the textbox. Do anyone know a way around this?

Thanks
________
list of subaru transmissions

 

[WayneRyan]

Durdle,

Get the table in Design View and (for that field), set Required = No.
Otherwise, it won't accept entries.

Wayne

 

[durdle]

Wayne,

I checked that and it was already set to No.
Any other ideas?

durdle
________
hz engine

 

[KenHigg]

Would you have to compensate for nulls?