Reusing a subform (1 Viewer)

Mihail

Registered User.
Local time
Today, 19:36
Joined
Jan 22, 2011
Messages
2,373
Hi !

Access 2007
I have 3 tables, T1, T2, T3 and 3 bounded forms to this tables F1, F2, F3
One more table T4 that contain 3 fields that look up (FK) on the previous 3 tables and a form F4 bounded to this table.

I need to use F4 as subform in each of the first 3 forms.
So, the "active" FK will change based on form where F4 is used as subform.

OK. This is done.
But, with my actual approach, looks (very) ugly and confused for the users.

My actual approach is to lock and disable the field/control that represent the FK at a certain moment.

Is there a better way ? Other than to create 3 copies of F4 with slightly differences in the fields arrangements ?

Hope I explained well the problem.

Thank you !
 

James Dudden

Access VBA Developer
Local time
Today, 17:36
Joined
Aug 11, 2008
Messages
369
It sounds like what you've done is right but maybe locking/hiding certain fields or adding labels could clear things up. You can set the screen as required depending on the parent by using the OnOpen Event of the form.
 

Mihail

Registered User.
Local time
Today, 19:36
Joined
Jan 22, 2011
Messages
2,373
Thank you for answered, James.

I have think to hide the fields/controls. This will end up with gaps in my subform unless I'll move the controls at run time.

Maybe someone have a better approach ?!
 

Users who are viewing this thread

Top Bottom