Click on record in subform to move to that record in new form

[jonasjacobs87]

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

 

[pbaldy]

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.