Edit Data in Forms

A

AccessIlliterate

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
 
B

Beetle

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

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.

Thanks for your help!
AccessIlliterate
 
B

Beetle

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.
Click to expand...

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.
 
L

Linq Adams via AccessMonster.com

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?
 
A

AccessIlliterate

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
 
A

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
 
B

Beetle

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.
 
A

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
 
Top