Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 44
  1. #16
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282

    OK, I've tried the first option, probably done something majorly wrong here though - I just get an empty dropdown box - there is definitely an Assessor in the table.
    Click image for larger version. 

Name:	Assessor Error Dropdown.png 
Views:	33 
Size:	5.9 KB 
ID:	23263
    Here is the properties section for the combo box (to show you I put it in Row Source... whether that's right or not I don't know.)
    Click image for larger version. 

Name:	Assessor Error Properties.PNG 
Views:	32 
Size:	8.2 KB 
ID:	23264
    And below is the query I used to build it.
    Click image for larger version. 

Name:	Assessor Error Query.PNG 
Views:	32 
Size:	13.2 KB 
ID:	23265
    I assume I won't need the Search button for this method?
    Also I haven't done anything to the Assessor Details in the form to get them to populate yet, how do I go about that?

  2. #17
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You'll need to include those other fields in the query if you want them available. I assume the query returns records? Can you attach the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #18
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    After much trial and error I have managed to upload the database, hopefully this will help speed things along.

    Yes, the query (FindAssessor) does return records (just so you don't have to look yourself).

    The forms I'm having problems with are 'Add Assessment Record' and 'Assessment Records Form' (the first will allow the user to add the record, the second allows the record to be viewed and edited). Hopefully once I know how to do it for one of the forms I can do it for the others.
    Attached Files Attached Files

  4. #19
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I deleted the other posts. The form you reference looks at another form, which looks at another. What steps would I follow to replicate the problem?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #20
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Thanks. If you just open the 'Assessment Records Form' and enter Child ID 2 it should skip the unnecessary bits from before this.

  6. #21
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    I have another problem... one of my forms looks fine in design view, everything is where it should be but if I choose Form/Layout view I just get a blank screen and Datasheet view just gives me a blank table. (screenshots of each are below) I can't think of anything I've done that could have made this happen and all other forms seem fine.
    Design View:
    Click image for larger version. 

Name:	Medium Risk Assessment Blank Design View.jpg 
Views:	27 
Size:	211.7 KB 
ID:	23297

    Form View:
    Click image for larger version. 

Name:	Medium Risk Assessment Blank Form View.jpg 
Views:	27 
Size:	91.1 KB 
ID:	23298

    Datasheet View:
    Click image for larger version. 

Name:	Medium Risk Assessment Blank Datasheet View.jpg 
Views:	26 
Size:	138.9 KB 
ID:	23296

    After having an in-depth look, my Medium Risk Query is also producing a blank table (even when I enter ID's when it asks for it)
    Click image for larger version. 

Name:	Medium Risk Query Blank.jpg 
Views:	28 
Size:	123.8 KB 
ID:	23299

    This is the design view of the query:
    Click image for larger version. 

Name:	Medium Risk Query Design.PNG 
Views:	27 
Size:	163.6 KB 
ID:	23302
    This is all despite my record still existing in the Medium Risk table. I would have thought it was due to my query not pulling anything through, but as things like buttons also aren't showing up, I'm just lost as to what to do.
    Thanks again for your help...

  7. #22
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The blank form can result when the underlying query returns no records, and either the query or form doesn't allow new records.

    The issue I see in the #Name issue is that you can't refer to a query like this from a form control:

    =[FindAssessor]![Forename]

    The FindAssessor query returns no records because the control in the criteria doesn't exist.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #23
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Why does it remove the buttons etc. as well though?

    Either way, I can't see why it the Query is blank - It's set up exactly the same as low and medium risk both of which work and:

    The Medium Risk table has a value
    Click image for larger version. 

Name:	Medium Risk Table Blank Form.PNG 
Views:	22 
Size:	5.9 KB 
ID:	23313

    The query is referencing the "Low Risk Assessment Form"s "Assessment ID"
    Click image for larger version. 

Name:	Medium Risk Query Design.PNG 
Views:	22 
Size:	3.7 KB 
ID:	23316

    Which has the same value as the "Assessment ID" in the Medium Risk Table
    Click image for larger version. 

Name:	Low Risk Assessment Form.PNG 
Views:	22 
Size:	9.7 KB 
ID:	23314

    (And hasn't been renamed)
    Click image for larger version. 

Name:	Low Risk Assessment Form Design View.PNG 
Views:	22 
Size:	2.9 KB 
ID:	23315

    Thank you for your help with the Find Assessor, I guess sometimes you need someone else to look at your work to see the problem with something that simple.
    Unfortunately I do have another problem with this part of the form... however, I can't fit it on this post due to the restriction of images, please see the next post
    Last edited by Heathey94; 01-08-2016 at 10:11 AM.

  9. #24
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    So, the other problem... as you can see, I now have 2 Assessor's listed:
    Click image for larger version. 

Name:	Assessor Details Table.PNG 
Views:	22 
Size:	9.8 KB 
ID:	23319

    The Assessment Records form is based on the Assessment Records Query so that the Assessment ID and Person ID are pulled through, however I believe the fields below the line need to be based on the FindAssessor query... otherwise they just pull through the details for the Assessor already listed... even if I change the Assessor in the drop-down (as shown in the images below)
    Click image for larger version. 

Name:	Assessment Records Form Jones.PNG 
Views:	22 
Size:	9.3 KB 
ID:	23317Click image for larger version. 

Name:	Assessment Records Form Taylor.PNG 
Views:	22 
Size:	9.4 KB 
ID:	23318

    So just to clear it up, I want to be able to change the Assessor for the assessment (which changes the assessor's detail fields).

  10. #25
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The FindAssessor query refers to

    [Forms]![Assessment Records Form]![FindAssessor]

    Unless I'm blind there is no control named FindAssessor on the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  11. #26
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    Sorry, in the first post (23) I was talking about the medium risk form - until the last paragraph where I said how I now realise my mistake. Having corrected it, my problem is described in post 24.

    I think those post #s are correct, I'm on my phone and it isn't showing them :/

  12. #27
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Does this do what you need?

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  13. #28
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    It appears so, however it seems to only pull one field through - the position.
    Click image for larger version. 

Name:	Assessor Error Dropdown Form View.PNG 
Views:	20 
Size:	6.7 KB 
ID:	23349

    I have checked and the query in the combo box's row source pulls through all of the data and the only thing that is different in the other field's control source is the number in brackets... any ideas?
    Click image for larger version. 

Name:	Assessor Error Dropdown Design View.PNG 
Views:	20 
Size:	16.1 KB 
ID:	23348Click image for larger version. 

Name:	Assessor Error Dropdown Query.PNG 
Views:	20 
Size:	12.9 KB 
ID:	23351 Click image for larger version. 

Name:	Assessor Error Dropdown Query Run.PNG 
Views:	20 
Size:	11.8 KB 
ID:	23350

    I have created it for the Assessment Records Form as well, with the same result, however in the process I didn't realize I hadn't pulled position and organisation through, resulting in the Work Number populating the Position field, while when I changed the (1) in the positions field to a (2) it produced a blank cell like the others - so it's something to do with the referencing of the other fields.

    Also, you didn't respond to my problem with the medium risk query (post 23), I assume this was just an accidental oversight?
    Last edited by Heathey94; 01-11-2016 at 09:40 AM.

  14. #29
    Heathey94 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Location
    United Kingdom
    Posts
    282
    I just tried to create another version of the Medium Risk Query with the same result, so I'm thinking either I've been really stupid with my criteria, or Access just isn't able to find the Assessment ID I'm asking it to find.
    Last edited by Heathey94; 01-12-2016 at 08:32 AM.

  15. #30
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The usual suspect with the autofill problem is the column count property of the combo not being correct. Looks like it would need to be 8.

    I'll look at the query when I get to my computer.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Autonumber field not populating
    By Pete-RM in forum Forms
    Replies: 5
    Last Post: 09-24-2015, 08:05 AM
  2. Replies: 5
    Last Post: 10-20-2014, 10:32 AM
  3. Replies: 4
    Last Post: 11-21-2013, 05:06 PM
  4. Autonumber in multitable form
    By Fairlane in forum Forms
    Replies: 5
    Last Post: 08-29-2013, 06:15 PM
  5. Autonumber through a form, not a table
    By Kat-ness in forum Forms
    Replies: 2
    Last Post: 05-02-2013, 04:18 PM

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