Split form missing columns

[smbrr]

Hello
So I wanted to use "split" form just to have a little box on the side with the picture of the product everytime someone clicks on a record.

I did that, and it works, but for some reason, I can't seem to have all my table's fields in the datasheet part. Only the few fields I have bound to text boxes in the form part. I have around 80 or so fields, and only bound 5-6 important ones to text boxes + a picture.

Been looking everywhere and all I find is people trying to hide columns in the datasheet, but my columns aren't even here! My data source is clearly just the table (not a query), and when I right click and "unhide columns" I get only the few fields shown here, nothing more nothing less.

I don't want to go and create 80 hidden text boxes to have all my fields in there. What if there's a new field one day?

Please tell me how I can get all fields to show up, it blows my mind that I even have to google this.

 

[theDBguy]

Hi,

Unfortunately, when you use a form, it can only display what you put on it. In your case, you might consider using a form/subform setup instead. On the main form, display the picture and in the subform, display the table.

 

[Gasman]

If it is a true split form, that is how it works.

Search here for emulated split form for a more useful arrangement.

Here it is

 

[smbrr]

That's a very very strange design choice. I guess I'll build my own datasheet + subform system then.

Thank you.