Combo box and Subforms

[Geezer]

Trying to get a subform combo box to find a record but limited to the records in the subform.

Main form to subform relationship is one to many.

Started off using navigation keys to navigate through records which worked fine and limited the list to the subform records. But when I add a combo box find record field all records are shown rather than those limited to the relationship.

Have tried limiting the selection via a query, this works but the box doesn't work, not sure why.

Any help/pointers appreciated.

Thanks,

Gareth

 

[Geezer]

Sorted

Seem to have solved by problem.

Allow Edits = No on opening the main form. I have an unlock button which unlocks another subforms and fields but not this one. At least I've got one issue resolved.

Gareth