Populating a report and sub-report based on the primary key (filter)

[enquiries]

Hi

Trying to create a report that will be populated based on an ID selected in the combo box in the header. The reason behind this is because I only want to print an individual record at a time and only selected individual records. So this will be based on a query where the query will take the value given in the combo box as criteria. Problem I encountered is that when I try to create the combo box it doesn't show the values (I've done this before with forms etc and it's worked) but I have an inkling it is because I'm trying to use a primary key as opposed to a foreign key. The only reason why I'm not using the foreign key is because only some records will have those fields so I need the primary key to include ALL records.



Any help/readings/suggestions much appreciated

Thanks!!!

[burrina]

If the combo does not show your value(s) it is most likely because you do not have your Column Count and Widths set correctly.

[enquiries]

Thanks for replying, I actually just tested it in a form and it work perfectly fine. But it's when I create it in a report that I can't see it (I use the wizard). I've double checked the properties everything is set to visible, width is okay, even when I put borders around it, it just appears as a box no values and doesn't look like a combo box (no drop down arrow)

[burrina]

If it works on the form, then use the same code for your Report.

[enquiries]

I meant the combo box using the primary key, I'm not sure why a combo box won't show it's values in a report? Maybe it's the report properties. I'll play around with it.