Continuous SubForm ListBox 1

[hedidit]

Hi all,

I have a form with a subform. The subform lists all records associated with the main form.

The continuous subform has a list box that lists records from a table based upon a value in each subform record BUT the content of the list box isn't updating for each subform record... usually i'd look into using requery on the onload event but think this is for reports only?

Can anyone help me out with this?

Cheers in advance?

 

[IGPCS]

type in the after upadte or the on current of the main form
in the code builder

subform.listbox.requery

it should work

 

[hedidit]

Hi IGPCS, tried that and it's telling me that it doesn't recognise the name of the combobox on the subform.

I'm 100% sure I've got the name of the form and the combobox correct in my code, i wrote it as:

a.combo6.requery

Any other ideas?

Cheers for the quick reply.

 

[IGPCS]

what is the query on that listbox did you put a criteria to show you only fields that matches the mainform?

 

[hedidit]

The query / row source for the listbox is:

SELECT [REPORTS:All_Q&Ab].AID, [REPORTS:All_Q&Ab].Answer
FROM [REPORTS:All_Q&Ab]
WHERE ((([REPORTS:All_Q&Ab].QID)=[Forms]![SurveyIN]![a].[Form]![QID]));

(Doesn't access just write the nicest looking SQL?!)

 

[IGPCS]

and when the open the form and you what dose the list box or query show you ?

 

[hedidit]

When I open the form it shows the listbox repeated form each record on the continuous form which is correct but it shows the same values for each record BUT it should only show records relating to the [QID] field on the subform...

 

[TheAceMan1]

How are ya hedidit . . .

in the On Current event of the subform:

[blue]   Me![blue]ListboxName[/blue].RowSource = Me![blue]ListboxName[/blue].RowSource[/blue]

See Ya! . . . . . .

 

[IGPCS]

how do you guys enter the code in this forum to show in a code box

 

[IGPCS]

Group by [REPORTS:All_Q&Ab].QID
having ((([REPORTS:All_Q&Ab].QID)=[Forms]![SurveyIN]![a].[Form]![QID]));

 

[PHV]

show in a code box
To display this:

my code here

Type this:
[ignore]

my code here

[/ignore]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IGPCS]

thanks

<code>phv thats cool </code>

 

[IGPCS]

nopes

 

[PHV]

Why using angle brackets ? Reread carefully my previous post.

 

[IGPCS]

 ok got you

 

[IGPCS]

i got it this time thnkx

should i give u a star?

 

[TheAceMan1]

[blue] . . . how do you guys enter the code in this forum to show in a code box . . .[/blue]

Have a look at TGML MarkUp Language

See Ya! . . . . . .

 

[hedidit]

Hey TheAceMan1,

I'm good cheers how are you?

Anyway the code you suggested worked in that the list boxes now show the correct values in the list however only the list box on the first record of the continuous form shows the value selected by the user after the the form has been closed and then reopened.

I checked in the relevant table and found that the values selected in the list boxes on the continuous form records are being stored they're just not showing up as being selected after the form is clsoed and then reopened...

Does that make sense?

Cheers

 

[TheAceMan1]

hedidit . . .

Are you saying the listbox is in the [blue]detail section?[/blue]

See Ya! . . . . . .

 

[hedidit]

yep of the subform...