form that doesn't allow editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've got form based on query (joined sql). When I try to type in any of text boxes nothing
happens. I can't delete either. What should I do in order to allow editing in form.
Thanx
alekm
 
First make sure that the form's AllowEdits property is true. Next start
looking at the recordsource query. It may be read-only. The query may be
read-only for any of the following reasons:

- it is a summary query (uses Group By)
- crosstab query
- union query

There are many other reasons the query may be read-only. Check the following
resources for more information:

Online help - in Answer wizard type the following:
"When can I update data from a query?" - open the article by the same name.

ACC2000: How to Edit Records in Related Tables in a Microsoft Access
Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;304474
 
Back
Top