Yes or No!

[baba78]

Hi,
I have a form in my database on which I have a subform. I have made one of the columns/fields in this subform a Yes/No column. The problem is that now that users are entering data, once someone chooses yes or no on this field it automatically changes every previous entry on previous forms in the corresponding field to that answer – does anyone know why this might happen and how I might prevent it?!?

 

[Uncle Gizmo]

changes every previous entry on previous forms in the corresponding field to that answer

This is the correct behaviour, your check box will be linked to a field in a table, when you change the data in this field, then every other form that accesses that information will show the new selection. I can't see why you would want it to do anything else?

 

[baba78]

Maybe then I am mistaken in the type of field I want there. He subform asks a set of consistent questions, but depending on the inspection results (the data going onto the sheet) the answer yes or no or n/a will always differ, therefore I don’t want it to force that answer for every previous record, it would render the data meaningless….

 

[Uncle Gizmo]

So the form you are looking at, has a column with check boxes, when you change one of the check boxes the rest of the visible check boxes changing as well, Is that what you are saying?

 

[baba78]

I'm wonderinng if the problem i might have is this:
I created a form and want those records to be individual. But on this form i have created a subform containing a list of questions. Against those questions the inputter has to enter yes or no, and then a date (for the closing of actions), i would like these to be individual records too?
As things stand the yes/no is a combo box and when i select yes or no on one record it changes it to the same for every previous record.

 

[baba78]

Is anyone able to help with this - I'm really struggling....
Looking at my form I'm starting to realise what the problem might be; again, just to recap, i created a form and on that form i have a subform and in here there is a set of so many questions representing a number of fields. Against this, the entree needs to answer yes or no. What i'm finding though is that the once someone enters against these questions it becomes the same answer on each record, i.e. although when completing a new clean form, it is treating it as the one and same record....and i don't know how i can alter it so that for each record completed these answers can be recorded individually......

 

[Uncle Gizmo]

If you were to answer my previous question then I may have some more questions which may lead to a solution.

 

[KathyL]

Is anyone able to help with this - I'm really struggling....
Looking at my form I'm starting to realise what the problem might be; again, just to recap, i created a form and on that form i have a subform and in here there is a set of so many questions representing a number of fields. Against this, the entree needs to answer yes or no. What i'm finding though is that the once someone enters against these questions it becomes the same answer on each record, i.e. although when completing a new clean form, it is treating it as the one and same record....and i don't know how i can alter it so that for each record completed these answers can be recorded individually......

I can't tell whether your primary form is based on a table or on a query.
I can't tell if your subform is based on a table or on a query.
I can't tell how the linkages are defined between the primary form and the subform.

All of these have to be looked at to determine what could be causing multiple records to be updated at the same time.

 

[baba78]

So the form you are looking at, has a column with check boxes, when you change one of the check boxes the rest of the visible check boxes changing as well, Is that what you are saying?

Sorry, i thought i had answered it.
Yes, it is a column with combo boxes, when you answer yes or no to a question it changes the answers to the same in the corresponding field in previous records.

 

[baba78]

I can't tell whether your primary form is based on a table or on a query.
I can't tell if your subform is based on a table or on a query.
I can't tell how the linkages are defined between the primary form and the subform.

All of these have to be looked at to determine what could be causing multiple records to be updated at the same time.

Both the primary and sub forms are based on tables. I have no relationships established on the database.

 

[JANR]

Can it be something simple as a Ubound combobox in a continious Form, if so then this is the expected behavior. To prevent it you have to bind the combobox to the table.

JR

 

[jsv2002]

So do you want something like the attached?

 

[baba78]

So do you want something like the attached?

Yes, something like that!!

 

[baba78]

Can it be something simple as a Ubound combobox in a continious Form, if so then this is the expected behavior. To prevent it you have to bind the combobox to the table.

JR

They're not unbound, i have the combo box linked to the relevant tables....

 

[baba78]

It looks something like this...

 

[jsv2002]

If you are entering text into the field and not using as a check box then change the field to text (Not yes/no) and put in a validation rule.

If like my example you want a tick/checkbox use the yes/no field in your table and default to no. I assume your subform has its own table/query link by master child fields to your main form.

My example is such and the subform is a continuous form if you hve followed these principles it should work if not could you attach your database for us to have a look (I'd extract the form from mine but has to many related fields and is still in progress)

Good luck John

P.S. Forgot to mention if I am using a subform to store multiple records in a continuous form I create a seperate table (subformtablename_details) this contains only 2 fields the Main form Primary Key and the subform Primary key. I then create a query based on this and the table the subform details will be based on. See attached example (Just remember its only one form extracted from a DB so most of the command button features won't work but it should be enough for you to get the general idea)

 

[baba78]

Thanks very much John, I'll have a look and get back.

 

[Rich]

They're not unbound, i have the combo box linked to the relevant tables....

Table or tables?

 

[baba78]

Sorry, i appreciate i let this thread go a couple of weeks ago but I was taken off onto a different project and was unable to get back to it.
If anybody's still able to assist it would be a big help.

Rich
To answer your question i meant table, sorry. Just one.

John (jsv2002)
I'm unable to look at the zipped file, it says it's created on a later version of access. I would happily attach my own database for scrutiny but i don't know how i would do that, it's stored on a network here at work.
I don't know what you mean by master child fields...?
My subform is linked to a table, but because the subform is a series of standard questions what i believe is happening is that the table behind it is treating it as a continuous record, which is the opposite of what i want it to be. For each form and subform filled out i would like it to be represented in a table as an individual record/set of responses.....

 

[gemma-the-husky]

it is not enought for the yesno field to be on a form

it must be BOUND to a field in a table, so that each record can store an appropriate setting for the yes/no field.

it sounds like the yesno field is not bound in your case