Editing records in a form

klwilbur

Registered User.
Local time
Yesterday, 23:41
Joined
Oct 21, 2005
Messages
10
I have a very simple form that is populating fields with records from a number of tables (not queries).

I have found that I cannot edit any of the records from the form. Almost all of these fields are NOT key fields. When I click in the field, it simply selects the text in the field, but does not allow me to alter it (typing does nothing...the cursor just blinks). The same thing happens for blank fields.

I know this is a simple question, but I can't find the answer in help or searching this forum. I know it must be a simple setting (I think) somewhere but I've tried a number of settings in properties/forms.

Thanks,

Kelly
 
Although you don't see it as such, because you've used multiple tables your form is based on an sql statement, open that statement as a query and look at the joins
 
Rich said:
Although you don't see it as such, because you've used multiple tables your form is based on an sql statement, open that statement as a query and look at the joins

Rich, I'm sorry I don't understand your response. Could you clarify?

How do I open "that statement as a query" and what do you mean by "look at the joins?"

But more importantly, how does this help me enter data in a form?

Thanks,

Kelly
 
Kelly,

if you use a form to pull data from different tables, you should use queries to base your forms on.
In a query you'd join the separate tables based on the relationships you would define in the relationship window.

Open your form in design view.
Open the form's properties by right clicking on the little square top left on the form window.
Select the tab page called Data
There's a property called Record Source.
Check the property field.
If it shows something like SELECT..., then click on the button at the right with the three dots.
This will invoke the query builder.
Save the query and base your form on the form.

Now if the property field shows a tabl name, you'll have to create a query yourself and base your form on the query rather then on a table.

Remember, rule is that whenever your form refers to multiple tables, you need to use queries and base your forms on queries.

RV
 
RV said:
Kelly,

if you use a form to pull data from different tables, you should use queries to base your forms on.
In a query you'd join the separate tables based on the relationships you would define in the relationship window.

Open your form in design view.
Open the form's properties by right clicking on the little square top left on the form window.
Select the tab page called Data
There's a property called Record Source.
Check the property field.
If it shows something like SELECT..., then click on the button at the right with the three dots.
This will invoke the query builder.
Save the query and base your form on the form.

Now if the property field shows a tabl name, you'll have to create a query yourself and base your form on the query rather then on a table.

Remember, rule is that whenever your form refers to multiple tables, you need to use queries and base your forms on queries.

RV

I've tried several of the suggestions and it still doesn't seem to work. I'll explain.

First, I went through the process to invoke the query builder, then I saved the query. I then created a new form built on the query. I had the exact same problem...I cannot update any fields.

So, to sum up: I cannot update fields in any form regardless of whether it is built on a number of tables or one query (which is in turn build off of the same tables).

Any ideas?

Thanks,

Kelly
 
The data for a form comes from its RecordSource. The recordsource can be a table, a querydef, or an SQL string. If you can't update data in the table or through the query, your form is not updatable. So, the first thing to check is that.
 
Pat Hartman said:
The data for a form comes from its RecordSource. The recordsource can be a table, a querydef, or an SQL string. If you can't update data in the table or through the query, your form is not updatable. So, the first thing to check is that.

When you say, "the first thing to check is that (your form is not updatable)," what exactly (and how) am I supposed to check?

This has to be the simplest possible form. The tables are from simple excel spreadsheets. I can't update the form when it is built directly from the tables OR when it is built from queries built from the tables.

I still don't have a clear answer of why I can't update the data from the form.

Thanks,

Kelly
 
I'm bumping this topic up because I haven't found a solution yet.
Thanks,

Kelly
 
"That" is the potential reasons the form might not be updatable. Did you check the query? or the table? Can you update the data in those places? Does the AllowEdits property of the form = Yes?
 

Users who are viewing this thread

Back
Top Bottom