Newbie - List box of all related records

[Turncloud]

I have created a 'documents' table with 4 simple fields;
Reference, Filepath, Filetype, Date

The reference field relates to my supplier database which has one record per reference. It will be a one to many relationship with multiple records in the documents table for each reference.

I would like a list box on my main form with all the records in the documents table that have the same reference as the record being displayed.

I created a query like this;



how do I get the list box to only display the records that correspond? Do I put the criteria in the query or use something like a DLookup to extract the records?

regards
Simon

[offie]

if you're asking how to change what appears in a combo box depending on the form then make a combo box, go into properties, data, row source, click the 3 little dots, and add criteria along the lines of like Forms!... Or you can make a query and link the combo box to the query. Make sure to add a Refresh somewhere so that it updates.

[Turncloud]

I'm sorry, but I'm still struggling with this and I realise it should be really easy.
I created a list box and then populated it with the following query


but it displays the first record in the supp_linked table on all records.



any pointers much appreciated

regards
Simon

[amrut]

You need to requery the listbox whenever you move from current record. In the commnad button's code which move to Next and Previous record, you need to put a line of code

Me.YourListBoxName.Requery

I would suggest you to use a sub form instead of list box which will automatically display related records. Create a new form based on the query and drag it to this form. Link the master and child fields.

[Turncloud]

Amrut, you are a star. The requery works fine - I'll take a look at using a subform when I have more time. Thanks

[amrut]

Glad to help
Please mark thread as solved.

[Turncloud]

I would love to - how do I do that ?

[offie]

Thread Tools up top on bar, Mark as Solved.