Too much magic in access forms

[martingaleh]

I'm trying to make a continuous subform in a main form. The two forms aren't linked. I've done this a million times before. But now, I get a form like this:



When I should be getting a form like this:

I know I have records because the sql for the form produces results:

And I checked the format, data and other properties and they are largely the same. When I enable the records box, it shows 0 records, or one record when I allow new records to be added to the form. Also, it is unfiltered. I checked that too, there is no filter on the form other that what was on the sql natively.

When I first made this subform, it did what I wanted. It showed 8 records. It was only after awhile that it changed into a form with no records. I tried to switch between the design view and the form view as I made incremental changes, but I haven't been able to trap the error I'm making. I think it's just the progress of time that results in this error. Maybe someone else has had this problem before.

I have another issue. You see how the correct subform has a button in it. it's an unbounded button. I tried to make a subform on the right called [Monica subform for Quotes] with a button just like the one on the right and I don't think I'm doing anything different from before. Yet, access refuses to show the button
Here it is in design view

To be continued...

[martingaleh]

... And there is no button

Yet, when I open the subform by itself, it starts out with no button

But the button magically appears when I press the design view button


Freaky I tell you.

[orange]

Aw come on Martin really ..."I've done this a million times before."

I don't use 64 bit Access, and have no experience with Sharepoint, but your post reminded me of an old joke.

Mother to child----If I've told you once, I've told you a million times, don't exaggerate! Couldn't resist.

[ItsMe]

You do not get a Button in Datasheet View.

For the other issue, is your continuous form opening in Add/DataEntry mode?

[martingaleh]

I can't believe it. So easy, and yet I was combing the properties for a million hours

[ItsMe]

Here is a description how to mark a thread as solved.
https://www.accessforums.net/forum-s....html#post4155