stop the "data entry" field from changing when a form opens

[Jaymin]

I hope someone can help me,
I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types of the first subform is selected it allows you to enter the second subform so you can enter new data about the clothing that was selected from the first subform.
In the properties of the second subform i have the "allow additions" and the "data entry" fields set to "Yes".
My question is, when i run the form and select the name from the form combo box the "allow additions" in the second subform stays "yes" but the "data entry" field changes to "no", when i open the subform in design view these fields are still set to "yes" is there a way of stopping the "data entry" field from changing to "no'' when the form/subform opens.
Peter

 

[Mr. B]

Take a look at the Access help file on the properties of Allow Additions and Data Entry. (While your cursor is in one of these properties, just push the F1 key.)

You do not need to try to set both of these properties to Yes at the same time.

Data Entry property:
"You can use the DataEntry property to specify whether a bound form (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.) opens to allow data entry only. The Data Entry property doesn't determine whether records can be added; it only determines whether existing records are displayed." ..... "The DataEntry property has an effect only when the AllowAdditions property is set to Yes."

Allow Additions property:
"
Set the AllowAdditions property to No to allow users to view or edit existing records but not add new records." ... "If you want to open a form for data entry only, set the form's DataEntry property to Yes."

 

[Jaymin]

I just want them to be able to add new records only, not see, edit or delete other records.
Peter

 

[Mr. B]

Set the Data Entry property to Yes. This will cause that form to only allow the creation of new records.

 

[Jaymin]

Mr.B,
I know that it will only allow new records, but when i run the form, access changes the data entry property to no, this is what i want to stop, access from changing this property.
Peter

 

[Mr. B]

So, just to be sure that I understand completely, you have Allow Additions set to Yes and Data Entry set to Yes. When you open the form the Data Entry property is immediately set to No.

Does the form open to a new record for data entry? Does the form allow you to locate or edit an existing record or are you only allowed to add the data for the new record?

Is it possible for you to post the database so we can see what is going on?

 

[Jaymin]

Mr B
when the form opens and nothing is selected all is ok, and additions and data entry are set to yes, when you select the conbo box for a name this populates the first subform, and also causes the second subform to be populated with previous data, if you look at the properties for the second subform data entry has changed to no.
Have included database, how it works is when you open it up select form "2-startup", in the combo box select Gold Coast, this opens the main form with the combo box and the 2 subforms, in the combo box select jim christiansen, you will see the first subform will be populated with 4 items coats and trousers, now you will see that the second subform gets populated with data, I do not need the second subform to have data in it , if you look at the properties menu "data entry" is set to no, i need the subform able to enter the single entry, that is all i need, that would happen if i could stop that data entry property changing to "no" by it self.
may be the design of the form needs to be changed.
Peter

 

[John Big Booty]

The reason your Sub forms are reverting to Allow Data Entry = No, is because they are both being populated by select queries, so by definition the Data Entry property must be set to No.

I'm having some trouble getting my head around your form structure and hierarchy, given that you have sub-forms within sub-forms within sub-forms so I really can't advise further. Perhaps if you laid out the data entry process you are trying to achieve that might help.

 

[Jaymin]

John,
Thank you for your reply,
I am a fireman, I am trying to develop a program that allows me to record when and what the fireman have done to their personal protective equipment (PPE) either cleaned/ repaired or decomtaminated.
I wanted to first filter staff by their station selected by a combo box - then by their names at that station by another combo box which will give me a list of PPE allocated to them, which is only 4 items - 2 coats and 2 pairs of trousers - when I select one of these cloths items it brings up a form so they can enter what was done to that PPE either cleaned/ repaired or decomtaminated. It will only be one entry per piece of PPE at a time and no need to edit, delete or see other records. so they might clean one set of PPE at a time.
Hope this makes it clearer what i am trying to achieve
Peter

 

[John Big Booty]

You should be able to achieve the first part by using a series of Cascading Combo Boxes.

 

[Jaymin]

John,
i assume that after I use the cascading combo boxs this would end in a form that will allow me to only enter the data i need. i will have to have a read how to do the cascading combo boxs, thanks very much for your help.
Peter

 

[John Big Booty]

Here's a very quick re-imagining of how your DB might work. Hopefully it will put you on a better track.

 

[Jaymin]

John ,
Thanks for all your help, I will have a look at how you did what you did, it looks like a better and even a easer way, once again thank you very much for your time and help.

Peter