Recent content by aladinabox

  1. A

    How to populate subform fields when drop down selected in main form

    Hi jDraw, Thanks so much for the quick reply. Please find database attached. You will see the General Contact Info form. That is the one I am working on. The course ID in the main form is linked to populate the Common Awards subform with the Modules attached to each of the courses. I'm...
  2. A

    How to populate subform fields when drop down selected in main form

    Hi, I really hope someone can help me, I've been trying to get this working for weeks now. I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at...
  3. A

    Autofill a subform based on the record selected in Main form

    I did as you advised, and seperated out the tables after reading in more detail the website link you had sent me. I'm just wondering could I have your assistance one more time. I have most of my tables set up and I'm trying to create the form with subform, and I'm wondering on the best way to...
  4. A

    Autofill a subform based on the record selected in Main form

    Ok, thanks Bob, will do.
  5. A

    Autofill a subform based on the record selected in Main form

    Hi Bob, one last question, do you think I should start the database over? I'm still messing around with it, but not getting anywhere. Thanks.
  6. A

    Best way to view table data on subform?

    Hi, I'm just wondering if someone could point me in the right direction with this: I have a table that holds "course codes" with the corresponding Module title and module codes, and assessment titles and codes that are used in each of the courses, so I have a few records that will go against...
  7. A

    Autofill a subform based on the record selected in Main form

    Thanks for that link Bob, I appreciate your time. I'm not sure I still fully understand the best way to go about it, is it that I should have a one to many relationship to the tblAssessmentTitleAndCode?
  8. A

    Autofill a subform based on the record selected in Main form

    The database is being used to record all training courses run in a company, the tblAssessmentInformation is to store the Modules and Assessment that are linked to each training course and needs to be updated with dates of tests, but I wanted this to pull the Module Title and module code from...
  9. A

    Autofill a subform based on the record selected in Main form

    I have the module title and module code from tblAssessmentTitleAndCode appearing in this subform, I was hoping I could perform some kind of lookup against the course code in the main form, that would look for the same course code in the tblAssessmentTitleAndCode and fill the module titles and...
  10. A

    Autofill a subform based on the record selected in Main form

    I have attached the db in 2003 format. You will see the Record of Common Awards AIS form, this is the form I'm referring to. I would like to be able to make the subform look up the tblAssessmentTitleAndCode, and based on the Course Code field, to autofill the Module Title and Module Code with...
  11. A

    Autofill a subform based on the record selected in Main form

    Hi Bob, Thanks for the quick response. I have the Link Child Fields and the Link Master Fields properties set up, I have them linking through Contract Number, then through the Course Code. What I want then is the rest of the fields to be autofilled from the values that are in the course...
  12. A

    Autofill a subform based on the record selected in Main form

    Hi, I'm fairly new to access and have been trying to figure this out for days now and cannot come up with a solution, someone will probably know how to do this straight away! I'm hoping anyway. I have a database with a main form that displays all details relating to a particular item. On...
See more
Back
Top Bottom