Subform on continuous form?

[daveUK]

I have a subform, which allows users to select several offices that they want to send a task to (the task details are on the main form). I then have a continuous form, which displays the outstanding tasks and the offices, which are associated with the tasks.

Unfortunately, Access will not allow me to place the subform onto the continuous form, so I have come up with the idea of placing a listbox onto the form and displaying the relevant offices for each outstanding task, but I'm having a few problems.

At the moment each task is displayed depending upon the number of offices selected (i.e. if there are 4 offices, the task is listed 4 times) and only the offices associated with the 1st task are displayed within the listbox (i.e. if offices A, B and C are associated with the 1st task, they are also displayed next to all of the other tasks).

Any ideas, or maybe there is a better way to do this?

Thanks

 

[Meltdown]

Even though Access will switch a main form into a Single Form when you place a sub-form, you can just open the properties box of the main form and switch it back to continuous form, everything seems to work as normal.

 

[daveUK]

Thanks for the reply, but whenever I try to change the form's properties back to continuous, Access displays an error message telling me that subforms cannot be placed on continuous forms.

 

[Meltdown]

What section of the form do you have the sub form in, header, detail or footer?...what version of Access are you using?

 

[Rich]

put the subform in the footer

 

[daveUK]

Sorry, I should have mentioned that the subform needs to be in the detail section, as it will be different for each record.

 

[Rich]

it will be different for each record, provided you link the child/master fields and put it in the footer, other than that you'll have to use a popup form and button with the usual linkage between the two

 

[daveUK]

Thanks Rich, I'll give it a try and see which the users prefer.