Referring to a control in a subform

L

Leif Thorsen

I have a form (B1) with a subform (B11) showing let's say 4 linked items
where the name of the linked field is "ID". When I doubleclick in a field in
the item 3 in the subform I want to open the same form in an expanded wiev
just showing only all information of item 3 only.

I have made a macro for this function as follows:

ID = Forms!B11!ID but this don't work.

What shall that macro contain or do You have any other way to solve the
problem ???

Tank You in advance
 
K

KARL DEWEY

I miss-read your post. If the ID is the linked field then it will return
many records from the subform. You have to use a different field or
combination of fields (ID with another) to get unique record associated with
the ID.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with form--subform 5
Access Reference Subform's Control 0
Link subform ID control 3
SubForms 4
Open form for record selected in subform 2
Inactivate a subform upon a choice. 1
Use TextBox on the main form to limit SubForm 2
looking for strategy for subForm filter 6

Top