sometimes form opens table in read only mode?

[Zorro1265]

I have a data entry form(A). This form can be loaded in two ways. The 1st is from a search page which loads and allows data to be entered, this works fine. The second way to load said form is from another form(B). I have a command button to load formA from formB. The form loads displaying the correct record and I can change the data in any 1 field. When I try to change another field I get an error "table " is read only". Any ideas? Zorro

 

[binky]

Zorro,

I think that the form is probably read-only in both instances, once you move to a new field Access tries to update the first one. That is why you get the error. Make sure you are calling the form(a) properly from the original form(b). You need to indicate the form mode in the call.

DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]

If you leave this argument blank (the default constant, acFormPropertySettings, is assumed), Microsoft Access opens the form in the data mode set by the form's AllowEdits, AllowDeletions, AllowAdditions, and DataEntry properties.

Try changing these properties.

hth
Ken

 

[Zorro1265]

In the first instance I can edit all the fields as its supposed to work. If I call up the same record using the second method (formA to formB) I can edit only 1 field and then the table is read only. I will look into the properties but if it was read only all the time how could I make the first change without getting an error? Zorro

 

[Zorro1265]

Well I am still stumped with this, so I am begging for more aid. As I explained above when loading formA from formB one of the tables gets locked and won't allow edits. I minimize the form and go directly to the table and its still locked. If I load a second form in between, such as a dummy timed form, then the table feeding formA is no longer locked. HELP!! I am so confused!! Zorro

 

[Zorro1265]

Any thoughts?, things to check, places to look for goofs?? Zorro