Subform not showing text/combo boxes

[dkelly]

Hi Everyone,

I am working on a quote form that is split into sections that pull data into a number of tables. This is where I have gotten to so far though:

• Quote Header - This is where the quote reference (auto number) will be held, and will hold the header data on the quote: date, overall value etc.
• Quote Labour - Any labour costs will be pulled into this table and a subform will be used to populate the data.

On the labour table I have added a manual number field called QteNumber linked to the ID on the Quote Header table (called QteNo so I didn't confuse myself). I have added a one to many relationship to the tables.

On the quote form I have the quote reference and another field linked to the Quote Header (Enquiry Number), the rest is unbound which will be added to tables via VBA once the form is complete.

I have another form (continuous) for the labour, which I have added as a subform to my main form. I have created the necessary relationship on the subform however, when I have tried to test it nothing shows up. I get the labels, but the text boxes and combo boxes in the detail of the subform aren't showing.

I have created a PO template in the past which works perfectly and have used the exact same properties/relationships to create this new quote sheet but for some reason the detail section of my subform isn't visible.

Can anyone help with this please?

 

[Micron]

What do you see when you open the subform directly from the navigation pane? Perhaps you have set the Data Entry property to yes/true, but there are other possibilities. If you can see labels, they must not be attached to their controls.

have used the exact same properties/relationships to create this new quote sheet

I see that sentiment often. It has yet to be exactly true. Anyway, review this for the other reasons.

Microsoft Access tips: Why does my form go completely blank?

Explains why no controls show on Microsoft Access forms sometimes, and how to address this issue.

allenbrowne.com

 

[dkelly]

Hi Micron,

I found that settings were not saving correctly, and reverting back when the form was closed (no idea why). I have recreated the subform and it seems to be working.

 

[Micron]

You cannot alter and save form properties when it is in form view. They can only be saved in design view, either manually or via code. In the latter case the form doesn't have to be visible.