Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Yeah, it clears when I update any of the combo boxes, but initially there is information in the subform, which ideally should be removed. Maybe assessor name (and the AssessmentDate and ReviewDate) should just default to null?

  2. #32
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    On the main form, add this code in the "OnLoad" event:

    DoCmd.GoToRecord , , acNewRec

    The reason is that when you open the form it reads the first record from your record source, TblAssessment and populates the AssessorID from the first record on that table.

  3. #33
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    it still briefly attempts to show data, but it'll do - thanks for all your help

  4. #34
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Can't say that I see that, maybe you have a faster connection than me!

  5. #35
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    I wouldn't have thought so, this machine is pretty old... Still, it works so I'm happy

    Out of curiosity, do you think the subform method you mentioned here, will work for my problem on the AddLowRiskAssessment page? Thread available here: https://www.accessforums.net/showthread.php?t=62079

  6. #36
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    From a brief look, I would think that the scenario's are identical: select Behaviour from a combobox (as AssessorID) and display it's data.

    This may have one small difference, however, the user would want to see the behavior data before they make their selection, not after? In which case a list box might be nicer.

  7. #37
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Well ideally all of the behviourIDs would be displayed, not just those which are selected - so I was thinking of using a text box (which is locked) - as opposed to a combo box, and the rest of the fields are displayed in the subform.

    Actually, now I think about it, I might be able to just put it all in one subform... I'll have a crack at it next week.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Subform Requery
    By MTSPEER in forum Programming
    Replies: 15
    Last Post: 04-29-2015, 09:14 AM
  2. Subform Requery
    By MTSPEER in forum Forms
    Replies: 1
    Last Post: 03-12-2015, 08:20 AM
  3. requery subform
    By nswhit in forum Forms
    Replies: 2
    Last Post: 05-16-2013, 09:34 AM
  4. requery in subform
    By putte11 in forum Forms
    Replies: 7
    Last Post: 04-22-2013, 02:43 PM
  5. Replies: 3
    Last Post: 04-17-2012, 10:28 AM

Tags for this Thread

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