Subforms

[davethewelder]

Hi, I have a form which shows a patients assessment details and I would like
to display the address details from another table. When i use a subform it
displays in the datasheet view. Is it possible to display the subform in the
Form view?

thanks in advance.

Davie

 

[MikeJohnB]

Yesyou can have the subform display as a form. First select the subform
properties, right click the little square box that is made as the two rulers
come together on the top left of the form in design view. Select properties.
You will now see a list of the subform properties. Near the top of the list,
you will find allow form view set this to yes, set allow datasheet view to
no. set defaul view to single form. Close the form to save your new settings
and re-open it. Confirm you now see single form view on the subform????

You should now have the subform display in single form mode. Hope this
helps???? Let me know if it is ok?

Kindest Regards

Mike B

 

[davethewelder]

Mike, it worked a treat.

many thanks

Davie

Yesyou can have the subform display as a form. First select the subform
properties, right click the little square box that is made as the two rulers
come together on the top left of the form in design view. Select properties.
You will now see a list of the subform properties. Near the top of the list,
you will find allow form view set this to yes, set allow datasheet view to
no. set defaul view to single form. Close the form to save your new settings
and re-open it. Confirm you now see single form view on the subform????

You should now have the subform display in single form mode. Hope this
helps???? Let me know if it is ok?

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

 

[MikeJohnB]

Thanks for the response Dave, its frustrating when some don't bother to
answer so your feedback is most welcome and its my pleasure to know I have
been of some assistance.

Kindest regards

Mike B