Click on record in subform to move to that record in new form (1 Viewer)

Hi all,

I am working on a database with several forms with subforms. As you will probably learn from my question I have only limited knowledge of Access.
For this problem I only need some of the tables and forms in the uploaded file:

- Table klanten has client information
- Table honden has dog information
- Form honden
- Form klanten
- Subform honden

Each client can have different dogs.

On the form "klanten" there is a subform "honden". When I click the name of the dog in the subform I want form "honden" to open to the specific record of the dog I selected on the subform.

The WHERE-condition ="[hondID] = " & [hondID] does not seem to cut it.

Any help is appreciated!
Jonas

It works, you just have to make sure to select the desired record first. Probably because the textbox you're double clicking on is not enabled. It can receive focus, thus can't select a record.