Edit Data in Forms

  • Thread starter Thread starter AccessIlliterate
  • Start date Start date
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
 
What is the recordsource of the form? If it is a multi-table query, these are
often not updateable.
 
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
 
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.
 
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
 
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
 
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.
 
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
 
Back
Top