Unable to Edit SubForm

  • Thread starter Thread starter Robert Robichaud
  • Start date Start date
R

Robert Robichaud

I have a subform but I cannot change any of the Quantity values. For this
field, Enabled is set to Yes, Locked is set to No.

Any suggestions of where I should be looking?
 
I have a subform but I cannot change any of the Quantity values. For this
field, Enabled is set to Yes, Locked is set to No.

Any suggestions of where I should be looking?
Click to expand...

Check the subform's Recordsource Query - it may not be updateable.

Open the form in design view; view its Properties; on the Data tab
select the Record Source (first row). Click the ... icon by it, to
open a query design grid. Select the datasheet tool at the left end of
the toolbar.

Does the query have a *> new record row?

If not, check the online help for "Updateable" and/or post the SQL of
the query to a message here.
 
After checking John's suggestions, and if the problem isn't found try
opening the subform in design view. Before selecting/clicking anything on
the form select the view/properties from the main menu. Select the data tab
and make sure allow edits is set to Yes.
 
I'm having the same problem: my forms won't let me update.
Edits is set to yes but the query does not have a *> new
recor row. When I checked updateabl;e in the online help,
I found nothing.


-----Original Message-----
After checking John's suggestions, and if the problem isn't found try
opening the subform in design view. Before selecting/clicking anything on
the form select the view/properties from the main menu. Select the data tab
and make sure allow edits is set to Yes.
Click to expand...
Quantity values. For
this
Check the subform's Recordsource Query - it may not be updateable.

Open the form in design view; view its Properties; on the Data tab
select the Record Source (first row). Click the ... icon by it, to
open a query design grid. Select the datasheet tool at the left end of
the toolbar.

Does the query have a *> new record row?

If not, check the online help for "Updateable" and/or post the SQL of
the query to a message here.
Click to expand...


.
[/QUOTE]
 
John,

Yes I'm using SQL/Server. Thank you anyway. I'll keep looking.

Anyone else with some suggestions?
 
Back
Top