default value not working

[tubar]

im new so bare with me. after searching the net, i think my issue is that when the user opens my form a record gets created. Thus default value will not work. what happens is; the user fills out form 1 goes to form 2 and on form 2 i want a check box default value to be true...but its always false. any suggestions on how i can beat this?

the checkbox in question is adequite staff. the user gets the question, "was there adequate staff" if there was the "adequate staff box" would be true. what i have tried is i created a "dummy" checkbox (checkbox299) entitle no. and labled adequite staff checkbox as yes. on the form2 open insert the following

If Me.ADEQUATE_STAFF = False And Me.Check299 = False Then
Me.ADEQUATE_STAFF = True
Else
End If

 

[CJ_London]

Why can't you just set the default value for the control to false?

How are you applying the question? if using a msgbox then you could just use

Me.ADEQUATE_STAFF =msgbox("Was there adequate staff?",vbYesNo)

 

[tubar]

setting the default value of the checkbox or adding a message box still produces the error "you cant assign value to the object" im guessing because by the time the user gets to the question (on the second form) A record has already been created...i guess you cant apply a default value to a record when its already been created im looking for a work around. also tried setting default value in the table still no go

 

[Cronk]

Are you saying that the field in the table is Boolean (Yes/No) and you cannot set a default value?

If so, there must be some corruption in your database file. Or the database is read only.