Listbox in a form

[Ligaya]

Hello,

I have a a main form with 3 subforms in it plus a list box. All 3 subforms are synchronised with each other and I would like the list box to be as well.
How do I do this please?

I am desperate for an answer.

Thank you.
Ligaya

 

[WayneRyan]

Ligaya,

You haven't given a lot of detail here.

Assuming that you have some field (or fields) on your main form
that define which subform records to display.

The RowSource for your ListBox should be something like:

Select Field1, Field2, Field3 
From YourTable 
Where SomeField = Forms!YourForm!YourDefiningField

You can use the form's OnCurrent event to requery your listbox:

Me.YourListBox.Requery

hth,
Wayne

 

[Ligaya]

List box in a form

Hello Wayne,

Thank you for your reply. I shall try out your suggestion.

Regards,
Ligaya