Listbox on a Subform to Find a Record

[ddrew]

Is it possible to put a listbox on a subform where it will allow you to find a record on the subform? The wizzard dosen't sem to allow me to do it!

 

[pr2-eugin]

Is it possible to put a listbox on a subform where it will allow you to find a record on the subform? The wizzard dosen't sem to allow me to do it!

Come again !

 

[ddrew]

If you put a listbx on a main form it will allow you to populate it and find a record (wth me so far?) If you put a listbox on a subform, the wizzard dosent appear to give that option!

 

[pr2-eugin]

Because the SubForm is filtered/linked based on the Relationship keys between the two tables. If there is no link between the Main Form and Sub Form then what you are trying to do would be possible.

If this is not the answer you are looking for, simply explain in plain words what you want to do, so we could offer maybe any other alternative.

 

[ddrew]

OK i understand, there is a link between the subform and the mainform, so it would appear that it cant be done.

 

[pr2-eugin]

You can edit the Listbox's RowSource, to travel within filtered records of the Subforms recordsource.