Results 1 to 4 of 4
  1. #1
    shuto13 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    10

    [question & need help] subform became frozen

    hi,

    so i have made this form with subform

    Click image for larger version. 

Name:	form-subform.png 
Views:	9 
Size:	96.8 KB 
ID:	8395
    Tag No and Tag Code share the "master-child link"

    when I first made it, the subform works fine... I was able to select a data from Tag No, and the same data would appear in Tag Code. then I could insert values in the subform and make calculations (using calculated field)

    the problem,
    now the subform is like frozen, I cannot input data using the subform anymore. one thing I did was that I made a query that used the subform data (because I wanted to export the data). also in the subform are quite a few calcluated fields, which I've reinputted in the query.(since I needed the results of the calculated fields).


    could the query have done that?
    if not, what could have happened, and how can i fix this problem?

    thanks in advance

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Allen Browne has an excellent article that explains why Queries are frequently Read-Only:

    Why is my query read-only?

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    shuto13 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    10
    thanks Missinglinq for the link...:P

    figured it out... somehow the "Allow Additions" property of the subform got set to "No"...(-.-)a
    changed it and it works just as before...

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Glad you got it fixed!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Subform question
    By Hello World in forum Forms
    Replies: 4
    Last Post: 09-26-2011, 04:41 AM
  2. Quick Question about Subform
    By rgrwatson85 in forum Forms
    Replies: 2
    Last Post: 09-16-2011, 04:16 PM
  3. MainForm/SubForm question
    By 10 Gauge in forum Forms
    Replies: 5
    Last Post: 03-04-2011, 07:46 AM
  4. Subform question
    By Wayne311 in forum Forms
    Replies: 34
    Last Post: 01-26-2011, 11:42 AM
  5. Subform Question
    By Desverger in forum Forms
    Replies: 1
    Last Post: 08-11-2010, 02:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums