Subform not showing all results

[lloydmav]

I have a subform which takes data from a query. The main form is attached to a Action Plan table and the subform to a query from the TypeTask table. The query has a criteria set for the Action Plan ID. This action plan ID is taken from the recordset of the main form. So when the mainform loads, there are Action Plan records. The action plan ID from this record is then used by the query and subform to show the relevant tasks.

However the problem is that the subform works for the second action plan ID and any subsequent records but not for the first record.

Would anyone be kind enough to take a look a my database and see if they can spot the problem?

Give me a reply and I'll mail the DB

Thanks in advance

 

[casey]

Is your subform linked to your main form by any fields (Subform properties>>Data tab>>Link Child Fields or Link Master Fields set to some field(s)?

If so, your subform's results will be limited to the records in the main form.

Otherwise, look at the subform's recordsource using Querybuilder. Adjust the joins between the tables (line which connects the tables) and display the results until you've obtained the correct results.

I hope I understand your problem correctly.

 

[lloydmav]

I've just loaded that form for the first time today and it now works! I haven't changed anything but I can't find any problems with it anymore.

ODD!

Thanks for the reply though!