Linked Forms

[RexesOperator]

I decided to switch from a regular form/subform to a linked subform in order to get more of the subform on screen - there are over 50 fields and controls on it.

I have some fields disabled that should be enabled based on a command button click and vice versa with others. When I open the linked form the fields are not disabled - they are locked.

Is this normal behaviour for a linked subform? I can't seem to get the fields disable programmatically either.

I tried Forms!mainform.subform.form.txtbox.enabled = true but nothing happens. And I still can't enter any data.

 

[Uncle Gizmo]

>>>I decided to switch from a regular form/subform to a linked subform<<<

Do you mean you have changed from having the main form with a subform imbedded in it to having two separate forms?

If this is the case, then there is no link between these two forms, the link is only present when it is imbedded on the main form. When you separate it you are destroying any link effect.

 

[RexesOperator]

I had originally designed the form/subform with the form wizard. I used the form wizard to create a form/linked form. I didn't physically separate the two.

 

[Uncle Gizmo]

>>>Do you mean you have changed from having the main form with a subform imbedded in it to having two separate forms?<<<

I'm not quite following your answer, could you please explain it with regard to the above question?

 

[missinglinq]

As Uncle Gizmo has suggested, there really is no form/linked form construct in Access, other than a main form with a subform embedded in it. Calling/opening one form from another form, if that's what you're talking about, does not create a form/linked form.

As Ricky Ricardo used to say "Splain yourself, Lucy!"

 

[RexesOperator]

As Uncle Gizmo has suggested, there really is no form/linked form construct in Access, other than a main form with a subform embedded in it. Calling/opening one form from another form, if that's what you're talking about, does not create a form/linked form.

As Ricky Ricardo used to say "Splain yourself, Lucy!"

(I thought the quote was "Lucy - you've got a lot of splaining to do!"

If there are no "linked forms" what is this wizard doing? (see jpeg). The second form logically behaves exactly like a subform but it is physically separated from the main form. That is what I mean by "linked form" That is the term used by Access 2003.

The first image shows the linked forms wizard and the second shows the forms I created from the wizard. The light blue form is the main form and the darker blue one is the subform. The command button Site Details is the togglelink created by the wizard.

 

[RexesOperator]

Don't the images explain things?

 

[RexesOperator]

Could someone please take a look at this?