Edit a Form

[Julia]

I made a form from a table. I can edit the data in the table, but for some
reason, I can't edit the entries in the form view. I checked all the
settings, and "Allow Edits" "Allow Deletions" "Allow Additions" and "Data
Entry" are all set on "Yes".

Any ideas what the problem might be?

Thank you!

 

[Golfinray]

Make sure the table is editable. Are the arrow and asterisk at the bottom
highlighted or greyed out. Greyed out means not editable.

 

[Julia]

The asterisk is greyed out... how do I change that?

 

[Golfinray]

Pull the table into a query and add all fields in design view. Go to "querys"
at the top and change to a make-table query. Run the query. It will make the
table for you and it will be editable.

 

[Julia]

Yes, it was already based on a table. And no, setting the Data Entry to "No"
didn't work either...

hmm. Any other suggestions?

I thought the form was already based on a table.

Anyway, I assume that my comment didn't work?

Pull the table into a query and add all fields in design view. Go to "querys"
at the top and change to a make-table query. Run the query. It will make the
table for you and it will be editable.

The asterisk is greyed out... how do I change that?

[quoted text clipped - 9 lines]

Thank you!

 

[Julia]

no, it is not a linked table nor does it have a primary key

Is this a linked table?

Does it have a primary key?

Yes, it was already based on a table. And no, setting the Data Entry to "No"
didn't work either...

hmm. Any other suggestions?

I thought the form was already based on a table.

[quoted text clipped - 9 lines]

Thank you!

 

[Julia]

dynaset

... of the form that is.

If it isn't 'snapshot', then I'm out of ideas, and I'd go back to rebuilding
the table like Golfinray - 11-04-2008 15:19 suggested.

What is the recordset type?

no, it is not a linked table nor does it have a primary key

[quoted text clipped - 3 lines]

Thank you!