Cannot enter data into subform ?

  • Thread starter Thread starter TonyB
  • Start date Start date
T

TonyB

Hi,
I did post this question a day a or so ago but got no answers. I have a
subform datasheet within a form which displays data from a query. This shows
the correct data as the record number in the main form is changed. However
when I select a new record, and try to enter data into the subform, nothing
can be changed, and I get a windows sound event whenever I try to alter
anything in the subform ? I've tried to find out what's happening but have
drawn a blank. Can anyone suggest any thing to try to find why this is
happening ?
Thanks
Tony
 
Can you update existing data?

First you want to make sure that the query under the subform is actually
updateable. Open the query by itself and see whether you can enter data into
it or modify data. There are several reasons a query might be read-only.
Here are some references that will help you figure out what might be going
on in your query:

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

If you are still having trouble post back with the SQL of the query along
with some basic information about how the subform relates to the main form
(ie what are the tables and relationships between them).
 
Back
Top