Forms not connecting to database

I have a successful connection to my remote database (direct database connection) and can view/edit my tables. However I can’t seem to connect with the database through forms (e.g. simple insert form) . I also have a dynamic select field that uses a table source to populate the options, however only two of the data is visible with 2 other blank rows. My login form also does not work and I followed your instructions to set it up.