READ ONLY

[Guest]

Ok Im back again....another question I have is...on the subform I
created....when I select a choice from the drop down and error message comes
up saying that its read-only and can't be set.....what does that
mean?....thanks again..RW

 

[John W. Vinson]

Ok Im back again....another question I have is...on the subform I
created....when I select a choice from the drop down and error message comes
up saying that its read-only and can't be set.....what does that
mean?....thanks again..RW

It means that the control is set to read only (Enabled = No); that the
Form is read only (Allow Edits = No); or that the subform is based on
a Query which is not updateable.

There are other possibilities but these should be the likely ones...

John W. Vinson [MVP]

 

[Guest]

thanks...I just wasn't sure how to correct it? I looked at the items you
suggested....except for the query part....forgive me....im a novice....wasn't
sure how to find what you suggested......any help would be great.....

 

[Guest]

thanks...I just wasn't sure how to correct it? I looked at the items you
suggested....except for the query part....forgive me....im a novice....wasn't
sure how to find what you suggested......any help would be great.....

 

[John W. Vinson]

thanks...I just wasn't sure how to correct it? I looked at the items you
suggested....except for the query part....forgive me....im a novice....wasn't
sure how to find what you suggested......any help would be great.....

So the Form is OK, just not the query?

Open the Form in design view. View its Properties. The first property on the
Data tab is the Record Source - where the form gets its data. Is this the name
of a Table, or the name of a Query, or is it a SQL string (starting with
SELECT ...)?

If it's a table, the problem must lie elsewhere.

If it's a SQL string or a Query, click the ... icon by the property. A Query
Design window will open up. Click the datasheet icon on the left end of the
toolbar; you should get a query datasheet listing all the records to be
displayed in your form. Scroll to the bottom. Is there a "new record" line? If
not, can you edit data in the datasheet?

If not, go back to query design view, and select SQL from the dropdown of the
leftmost button in the toolbar or use the menu View... SQL, and copy and paste
the SQL text to a message here.

John W. Vinson [MVP]