Form severed from data

I’m a new user of Base, but adept at FileMaker and Access design. I just spent a few hours setting up a new database, tables, relationships, and form. It was working well enough. Now, when I open the form, it doesn’t seem to be connected to the tables anymore. I can make the navigation bar show, but everything is grey with no records showing. I can type in the fields, but nothing else happens. The menu options for Normal and Web are grayed out. What’s especially weird is that once the form is open in data entry mode, half the time the close button on the window stops working too. Then I have to close Base altogether to get the form to close. The data I entered still exist in the tables. The main form has one subform. The main form properties show the content type as a SQL command. When I open the SQL command, it appears to be empty. Did this get corrupted somehow? How can I fix it?

Here are the things I did before the form broke. I added a navigation bar within the subform area, thinking that might allow me to more easily browse through the subform records. I didn’t get a chance to see if it worked before the form broke. I added a rectangular background to the subform. (I’ve since deleted both of these, just in case.) Then I went into the main form properties to see if there was a macro to switch to Normal view upon opening the form. There wasn’t, so I closed properties without changing anything. Then I browsed around the macro organizer without doing anything. It was after that, when I opened the form in data entry mode, that it no longer worked.

Help much appreciated, or I will have to give up on Base and find something else. :frowning:

JB

Could you upload the database here?

You created datasource of the form by SQL. I never needed this function in any database. What’s the reason to create it in SQL?

Please show the properties of the main form, special the data folder.

You were right, it should not have been set to SQL command. I didn’t choose that, and I don’t know how it happened. Possibly by accident with the mouse pad as I was passing through that window, I don’t know. In any case, I changed it to Table and selected the main table, and it works again. Thanks!