Edit Data in Forms

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

Here's Allen Browne's excellent explanation of why some queries are Read-Only:


http://allenbrowne.com/ser-61.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

Thanks for your help!
AccessIlliterate

"Beetle" wrote:

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

I'm not exactly sure what you mean here. Either;

1) You have a form with two subforms, each with it's own recordsource table.

Or

2) You have one form that gets data from three tables.

If it's No. 2, then the only way that would be possible is if the recordsource
of the form is a query that combines the three tables, in which case it
will not be updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

Thanks for your help!
AccessIlliterate

"Beetle" wrote:

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

Sorry, but if the Record Source for the form consists of 3 tables, a query
has to be involved! That's the only way this can be done! In Design View for
the form, goto Properties - Data and what does it say in the Record Source
Property box?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Beetle, thank you for your help.

I have 1 form that gets data from 3 tables, but none of that information
comes from a query. When I created the form using the design wizard, I chose
all the fields from the 3 tables I want the information from. On 2 of the 3
table I do not choose the field that links all 3 tables together (Client
Code). At no point do I see the words "Read-Only" on the form, tables or
fields.

AccessIlliterate

"Beetle" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

I'm not exactly sure what you mean here. Either;

1) You have a form with two subforms, each with it's own recordsource table.

Or

2) You have one form that gets data from three tables.

If it's No. 2, then the only way that would be possible is if the recordsource
of the form is a query that combines the three tables, in which case it
will not be updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

Thanks for your help!
AccessIlliterate

"Beetle" wrote:

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

Thanks to you too LA;

The properties box contains a long list of the fields that I am using to
create the Form.

Here it is exactly: SELECT Clients.Code, Clients.Client, Clients.[Dom
Code], Clients.reimbcode AS Clients_reimbcode, [Client Plus].Parent, [Details
on Management Agreements].Agreement, [Reimbursement Codes].reimbcode AS
[Reimbursement Codes_reimbcode], [Reimbursement Codes].comments AS
[Reimbursement Codes_comments], [Details on Management Agreements].Status,
[Details on Management Agreements].ODate, [Details on Management

"Linq Adams via AccessMonster.com" wrote:

Sorry, but if the Record Source for the form consists of 3 tables, a query
has to be involved! That's the only way this can be done! In Design View for
the form, goto Properties - Data and what does it say in the Record Source
Property box?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Then Access created the query for you, but it's still a query. You are going
to have to redesign this using a form and sub forms.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

Beetle, thank you for your help.

I have 1 form that gets data from 3 tables, but none of that information
comes from a query. When I created the form using the design wizard, I chose
all the fields from the 3 tables I want the information from. On 2 of the 3
table I do not choose the field that links all 3 tables together (Client
Code). At no point do I see the words "Read-Only" on the form, tables or
fields.

AccessIlliterate

"Beetle" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

I'm not exactly sure what you mean here. Either;

1) You have a form with two subforms, each with it's own recordsource table.

Or

2) You have one form that gets data from three tables.

If it's No. 2, then the only way that would be possible is if the recordsource
of the form is a query that combines the three tables, in which case it
will not be updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

Thanks for your help!
AccessIlliterate

"Beetle" wrote:

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate

Beetle--thanks for the help. I am taking a Access online class and sub-forms
on part of level three and I am stil on two. Hope the tutorial will help me
create this form properly--Thanks again.

AccessIlliterate

"Beetle" wrote:

Then Access created the query for you, but it's still a query. You are going
to have to redesign this using a form and sub forms.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

Beetle, thank you for your help.

I have 1 form that gets data from 3 tables, but none of that information
comes from a query. When I created the form using the design wizard, I chose
all the fields from the 3 tables I want the information from. On 2 of the 3
table I do not choose the field that links all 3 tables together (Client
Code). At no point do I see the words "Read-Only" on the form, tables or
fields.

AccessIlliterate

"Beetle" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

I'm not exactly sure what you mean here. Either;

1) You have a form with two subforms, each with it's own recordsource table.

Or

2) You have one form that gets data from three tables.

If it's No. 2, then the only way that would be possible is if the recordsource
of the form is a query that combines the three tables, in which case it
will not be updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries.

Thanks for your help!
AccessIlliterate

"Beetle" wrote:

What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
--
_________

Sean Bailey


"AccessIlliterate" wrote:

I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to
edit the data in the tables. I have set all the "Allow" options in the form
selector to Yes but am still unable to make any changes. Please help!

Thank you,
AccessIlliterate