Page 2 of 6 FirstFirst 123456 LastLast
Results 16 to 30 of 84
  1. #16
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    once you select a behaviour from the combobox, it automatically assumes you want the same behaviour in the next bit of the form
    This is because you didn't



    Remove Behaviour Description and change BehaviourID to a combobox
    You can't have unbound fields on a continuous form, that is what happens.

  2. #17
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I don't see how it is working, even after a fashion. You are still

    losing the AssessmentID each time you add a record

  3. #18
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I tried the subform version, but that meant I couldn't make it a continuous form
    Why not? Subforms can be continuous too.

  4. #19
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Quote Originally Posted by aytee111 View Post
    once you select a behaviour from the combobox, it automatically assumes you want the same behaviour in the next bit of the form
    This is because you didn't

    Remove Behaviour Description and change BehaviourID to a combobox
    You can't have unbound fields on a continuous form, that is what happens.
    I was initially unsure if adding a control source to the combo box would work (looking back, I have no idea as to why I thought that). I've now added it and it works, thanks.

    Quote Originally Posted by aytee111 View Post
    Why not? Subforms can be continuous too.
    I tried the subform version, but that meant I couldn't make it a continuous form
    The form the subform was on wasn't able to be continuous - an error message came up, I didn't think the continuous form on the subform would be very good as it would potentially result in unnecessary scrolling.

    Quote Originally Posted by aytee111 View Post
    I don't see how it is working, even after a fashion. You are still
    losing the AssessmentID each time you add a record
    I wasn't sure what you meant by this at first (as I hadn't got as far as adding another behaviour), I've now amended this and that's working, although the combo boxes are returning the information in the table - "DoCmd.GoToRecord , , acNewRec" doesn't seem to work (and now that I think about it, it wouldn't because of the nature of a continuous form... I need to use an append query instead of using a table as the record source, don't I?)

  5. #20
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    If you go the subform route then the main form would not be continuous, in fact it won't even have a record source. It will be a place to (1) display the information that the user needs to see and (2) a place to store the AssessorID field (you don't say how you got this part working).

    I don't see when you need the "go to new record"?

    The unnecessary scrolling, I don't get that part either. What would be the difference between a form or a subform? The same number of rows will be displayed, surely.

  6. #21
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    If I use the subform route, there'll only be one behaviour ID so I won't be able to view more than one behaviour at once, will I?

  7. #22
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Not sure where you are going with this. The subform would be just the same as what you have now - a continuous form with all the fields from TblAssessmentDetails. The BehaviourID would still be a combobox showing the description where the user would make their selection, one per record. Yes they will only see one at a time. You could make a list box on the main form showing all of them if you think that the users will benefit from that.

  8. #23
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Yes they will only see one at a time.
    That's what I'm getting at.

    Is there any way I can get multiple behaviours' records to show at a time?

  9. #24
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You have two options - put it in the header section of the subform or anywhere on the main form (whether you use a subform or not). It will be a list box.

    If you want to get fancy, have them double-click the one they want and behind the scenes you can add a new record and get them to fill in the rest of the fields.

  10. #25
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    OK, this is how far I've got, I'm struggling to connect the behaviour IDs, I can't remember where they are meant to be on the property sheet.

    Also, is there a reason for the blank gap between the two sets of lines? for some reason they won't quite match up.
    Attached Files Attached Files

  11. #26
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I'm not sure what part of this statement you aren't getting, this is the third time I have said it :

    Remove Behaviour Description and change BehaviourID to a combobox
    I don't know what you mean about connecting the behaviour ID's.

    I don't know what blank lines you are talking about.

    You need to link the subform to the main form using the Assessment ID.
    You can't have the same table as the record source for both the main form and the subform. As stated above, if you use a subform then the main form won't have a record source.

  12. #27
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Here is what I mean.
    Attached Files Attached Files

  13. #28
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Quote Originally Posted by aytee111 View Post
    Here is what I mean.
    I tried double clicking on an item in your list box, it just came up with an error:
    Click image for larger version. 

Name:	ListBoxVBA.PNG 
Views:	9 
Size:	13.0 KB 
ID:	25939
    Debugging highlighted the first line of your code:
    Click image for larger version. 

Name:	ListBoxVBADebug.PNG 
Views:	9 
Size:	25.8 KB 
ID:	25940
    Any ideas?

    Also:
    I'm not sure what part of this statement you aren't getting, this is the third time I have said it :
    Remove Behaviour Description and change BehaviourID to a combobox

    I don't know what you mean about connecting the behaviour ID's.

    I don't know what blank lines you are talking about.

    You need to link the subform to the main form using the Assessment ID.
    You can't have the same table as the record source for both the main form and the subform. As stated above, if you use a subform then the main form won't have a record source.
    I forgot to remove the record source for the main form, sorry - my bad.

    When I tried to link the main form to the subform (when the main form didn't have a record source) I got the following message:
    Click image for larger version. 

Name:	LinkSubform.PNG 
Views:	8 
Size:	22.0 KB 
ID:	25941
    Am I doing something wrong?

  14. #29
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Did you open the form thru the right channels, not direct from the navigation pane?

    When the item comes up in yellow like that, you can hold the mouse over the variables to see what they contain. Let me know what is in the two ID fields.

  15. #30
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    No - I didn't think to check if you'd linked it up correctly.

    I just tried to, and the "DoCmd.GoToRecord , , acNewRec" you recommended I add in the other thread is now stopping me from opening the "AddAssessmentRecord" form...
    Click image for larger version. 

Name:	GoToNewRecordError.PNG 
Views:	8 
Size:	10.4 KB 
ID:	25942

Page 2 of 6 FirstFirst 123456 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-01-2016, 04:06 PM
  2. Replies: 1
    Last Post: 12-20-2015, 01:09 PM
  3. Replies: 4
    Last Post: 07-14-2015, 06:49 PM
  4. Replies: 2
    Last Post: 05-28-2013, 04:00 PM
  5. Sub form based on table select specific records
    By ReluctantGeek in forum Forms
    Replies: 0
    Last Post: 01-21-2012, 11:24 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