to dynamically set select lists and radio buttons, select the list or button in design view, then click the Dynamic button in the property inspector.
Click the lightning bolt next to select value equal to and then select the corresponding column from the recordset.
the "cannot be null" error is coming from the MySQL server.
It will happen if a column is set in the database to Not allow NULL values.
you will need to edit the table in a MySQL GUI Such as MyPHPAdmin and either set the column to allow NULL Values, or provide a default value.