dealing with customized subforms

Jimcb8

Registered User.
Local time
Today, 02:52
Joined
Feb 23, 2012
Messages
98
I have a form that I designed that contains two subforms.
The first subform is an entry subform so you can post the current client visits.
The second subform I want to just display all prior client visits and make updates or deletions if needed.

Now my problem:
It does not appear that I can make the first subform entry= yes additions allowed=YES in the properties.
The second subform I want entry=No and addition=no

When I pull up the properties sheet for each of the subforms these options do not appear. They appear only on the main FORM, FORM property sheet.
I thought I could create two new forms with the properties I desire and then copy them into the main form. I have had little success trying to accomplish doing this.

How should this be accomplished? I'm sure it is possible but the manuals are very unclear how to do this.

Any help is greatly appreciated.

Thanks,
Jim
 
Which properties do you have then?
Are you sure you really select sub-form, and not the "frame" around the subform in the main form?
 
JHB,
Thanks so much for responding I am really stuck.
When I bring up the main form, it contains the 2 subforms.
The first subfom has the Entry prompt with today's date as I want. Does not have any scroll bars or record navigation items, so it is great the way it is.

The 2nd subfrom when it comes up in design mode shows the frame only with the name in the upper left hand corner of the query used to sort the data in descending order. It shows all of the prior visits as it should, BUT it also shows a
* record for a new add, which it should not have if I could only tell it Entry=NO

Neither of the subforms when you bring up their property sheets shows under DATA the ability to say entry =Yes or a scroll bar choice. Only the FORM which contains the two subforms has those options. They are set to Entry = Yes and scroll bars= both

I hope the shed some light for you to point me to where I did something wrong.

Thanks so much for your help.
Jim
 
Take a look at the picture. (If it not helps show what you have then, show it not describe it. :) Or post the database, zip it.). And the form must be in design mode. To get into the sub form, click 2 times where the little black square is, first time the frame are selected, second time, then you are into the sub form.
attachment.php
 

Attachments

  • PropertySub.jpg
    PropertySub.jpg
    77.4 KB · Views: 153
Last edited:
JHB,
I figured out what I was doing wrong.
I should have create 3 forms
Main form
Form 1
Form 2
Then in the Main form
I have to DRAG Form1 onto Main form
Next I DRAG Form 2 onto Main Form

Since all of the items above are forms, I could then set the properties the way I wanted for each of my forms. Enter=Yes on one form Enter = No on the second form. It worked.

What I was doing was I created Main Form
then in design mode of Main Form I clicked on subform control in create mode and created a subfom within the Main Form. Since the subforms were created in the Main Form there is only one Form property for all three forms, instead of a form property for each that can be set separately.

I can't thank you enough for working with me to come to a solution.

Thanks again,

Jim
 
You're welcome - good you found the problem. :)
 

Users who are viewing this thread

Back
Top Bottom