Results 1 to 8 of 8
  1. #1
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57

    Unhappy stop the "data entry" field from changing when a form opens

    I hope someone can help me,


    I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types of the first subform is selected it allows you to enter the second subform so you can enter new data about the clothing that was selected from the first subform.
    In the properties of the second subform i have the "allow additions" and the "data entry" fields set to "Yes".
    My question is, when i run the form and select the name from the form combo box the "allow additions" in the second subform stays "yes" but the "data entry" field changes to "no", when i open the subform in design view these fields are still set to "yes" is there a way of stopping the "data entry" field from changing to "no'' when the form/subform opens.
    Peter

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Why do you want Data Entry set to Yes? This causes the form to only allow new entries and not display existing records.

    Could you provide the project for analysis? Attach to post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57
    yes that is what i want to do, to only add new entries and not allow anyone to see previous entries
    Peter

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The main form is unbound? The second subform is not a subform of the first subform (form/subform/subsubform)?

    Can you provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57
    June7,
    Thank you for your reply, the second subform is a subform of the first subform, did you want me to send the project to you? I want the second subform to be for additions only, no need to view, edit or delete any previous data
    Peter

  6. #6
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57
    June7
    Have included database, how it works is when you open it up select form "2-startup", in the combo box select Gold Coast, this opens the main form with the combo box and the 2 subforms, in the combo box select jim christiansen, you will see the first subform will be populated with 4 items coats and trousers, now you will see that the second subform gets populated with data, I do not want the second subform to have data in it , just a subform able to enter the single entry, that is all i need, that would happen if i could stop that data entry property changing to "no" by it self.

    Peter

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The only thing I can conclude is that the main form dictates this state for all forms.

    Alternatives:
    1. disable the Navigation bar and with code move direct to new record, use Single Form setting
    2. open a 'popup' form to a new record.
    3. unbound form and save data programmatically
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57
    June7,
    Thank you for you help, I have found a solution by using cascading combo boxs
    peter

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

Similar Threads

  1. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  2. Form error "the current field must match..."
    By plavookins in forum Forms
    Replies: 0
    Last Post: 04-13-2011, 07:42 AM
  3. Replies: 1
    Last Post: 03-30-2011, 06:16 PM
  4. Replies: 3
    Last Post: 03-07-2011, 08:37 PM
  5. Replies: 8
    Last Post: 11-12-2010, 10:55 AM

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