Some controls are locking when the form is opened

Discussion in 'InfoPath' started by valveless, Aug 8, 2011.

  1. valveless

    valveless

    Joined:
    Aug 8, 2011
    Messages:
    1
    Likes Received:
    0
    Hi all,

    I hope you can help me.
    I've been building a set of forms that are connected to an Access Database (I'm using the 2003 version of IP and Access).

    One of the forms is being used to read data from the table (using the data fields not the query fields) which allow the user to confirm and update/change data as required. Once they've finished, they submit the form back to the database. The form is connected to 3 tables (T1 T2 and T3) where T1 is the primary parent table and T2 and T3 are held beneath it related by 1 primary key.
    eg
    T1
    ---T2
    ---T3

    I'm having trouble with T3. When I open the form all the controls linked to T3 are locked/readonly, and the don't pull in the data from the dbase.

    I had this problem before (on the same form in a previous version) where I had 5 tables set up like this
    T1
    ---T2
    ------T3
    ---------T3a
    ------------T4
    where all the controls in T4 and T3a were locked, so I consolidated them into the three table structure above. This solved the problem but I've come back after the weekend and it doesn't want to play ball anymore.

    I've not been able to fnd anything relevant when googling my problem (I get no error messages, the connections are fine, and there's data in the table to be queried).

    Any ideas?
     
    Last edited: Aug 8, 2011
    valveless, Aug 8, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. niyaz.syed

    Browse Button in infopath Form

    niyaz.syed, Dec 20, 2011, in forum: InfoPath
    Replies:
    0
    Views:
    1,116
    niyaz.syed
    Dec 20, 2011
  2. Gailc
    Replies:
    0
    Views:
    1,034
    Gailc
    May 17, 2012
  3. Shayaan
    Replies:
    0
    Views:
    841
    Shayaan
    Jul 3, 2012
  4. karthikeyan
    Replies:
    0
    Views:
    702
    karthikeyan
    Jul 13, 2012
  5. karthikeyan
    Replies:
    0
    Views:
    1,038
    karthikeyan
    Jul 18, 2012
  6. Bob McCarthy

    InfoPath 2010 form in WinForms app

    Bob McCarthy, Sep 2, 2014, in forum: InfoPath
    Replies:
    0
    Views:
    771
    Bob McCarthy
    Sep 2, 2014
  7. DebMcAn
    Replies:
    0
    Views:
    321
    DebMcAn
    Dec 31, 2014
  8. Tess
    Replies:
    0
    Views:
    407
Loading...