subform controling main form (1 Viewer)

Lcrosspt

New member
Local time
Today, 01:31
Joined
Mar 12, 2007
Messages
5
hi
i have a form with some text controls and a subform in table view.
i need that when the user selects a record in the subform table the details are displayed in the main form, how do i do this?
I can do the other way around but this i can't.

Can you help me?????
 
Last edited:

neileg

AWF VIP
Local time
Today, 09:31
Joined
Dec 4, 2002
Messages
5,975
You can't if you have a form/subform relationship. Try using two subforms in an unbound main form and showing the detail in the second subform.
 

boblarson

Smeghead
Local time
Today, 01:31
Joined
Jan 12, 2001
Messages
32,059
And the reason why you can't while linked is that a SUB form is just that - a lower level (okay, maybe not the best term, but shows related info to the master, which is usually the one part of a one-to-many relationship) view of the data within the main form.
 

Users who are viewing this thread

Top Bottom