Custom Form Fields not Visible

Question

I've created a custom report and my fields (Patron ID, Title, First Name, Last Name, and Phone) are only visible in Design View. What Is the reason? My combo box, title and subform are all visible in each View.

Answer 1

Unfortunately, there is probably more than one possible reason for those controls not to be visible on this form (and it is a form, not a report).

One possibility is that there are no records in the form's recordsource, and that recordsource is a non-updateable query.

Also, in the design view screenshot, I do not see the subform. Is it in the Footer section, out sight in the screen shot? What are the Parent/Child Linking fields involved in it?

Thanks for providing additional information to help find suggestions.

Answer 2

The subform is in the footer section.

Answer 3

I thought that would be the case, thanks.

My other question, then, is also relevant.

In addition, we need to know if you have any code running in the form's Open or Load events.

Thanks.

Answer 4

Hi Ognjen.

I suspect the problem is because you are using a subreport and its not correctly linked to the main report.

But this is not how I would do a report like that. First, I would create a query that joins the Patron table to the donations table on PatronID. This assumes that the Donation table has PatronID as a foreign key. If it doesn't then your design is incorrect since it seems that it should.

I would then use that query as the Recordsource of a report. I would use the Report Wizard to build the report.. When prompted for the fields to incude I would only include the PatronID from the Patron table and all the fields from the Donation table.

Next, when prompted for a grouping level I would select PatronID. So now you should have a Group header band with PatronID and a Detail band with the Donation info.

Finally, I would add the other Patron fields and drag them into the Group header and arrange them as desired.

The results should be the report I believe you want.

Answer 5

The record source is tblPatron as instructed. The fields and their values were visible the other day.