Results 1 to 10 of 10

Thread: Quick Question

  1. #1
    Join Date
    Oct 2002
    Posts
    15

    Unanswered: Quick Question

    Hi, what's wrong with this syntax...

    Forms!Parts_form!All_Parts!Child0.Form.RecordSourc e = partsList & "_tmp"


    Forms!Parts_form!All_Parts!Child0.Form.Requery

    ...

    - Parts_form is the main(parent form).
    - All-Parts is the subform(child form) inside Parts_form
    - Child0 is the white box thing where I want the data from the table partsList & "_tmp" to appear


    Can't figure this out, please help a newb :-)
    -The enemy of good is better...

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Parts_form is the main(parent form).
    - All-Parts is the subform(child form) inside Parts_form
    - Child0 is the white box thing where I want the data from the table partsList & "_tmp" to appear

    Forms!Parts_form!All_Parts!Child0.Form.RecordSourc e

    This code reads (set the recordsource for ) Form called Parts_form having a subform of All_Parts, with a subform of Child0 and then proceeds to set the record soure of the form Child0. I don't this this is what you want.

    Try:

    Me("Parts_form").Form("All_Parts").Form("Child0") =

    I have substituted (" ") for the !, as I find it confusing using ! and . .

    This now reads Me, the parent form called Parts Form having a form called Allparts which is a form containing a control called Child0.

    I think this will help.

  3. #3
    Join Date
    Oct 2002
    Posts
    15

    Still not working

    Thanks for the reply, I tried what you said and got this error message...

    Run-time error '2465'
    Microsoft Access can't find the field "Parts_form" referred to in your expression.


    ...
    this is the code that is activated after an update of a combo box, the combo box is in the parent form (Parts_form)

    Me("Parts_form").Form("All_Parts").Form("Child0"). RecordSource = partsList & "_tmp"

    Me("Parts_form").Form("All_Parts").Form("Child0"). Requery


    I'm really lost, any help would be great, thanks
    -The enemy of good is better...

  4. #4
    Join Date
    Feb 2002
    Posts
    403
    Im sorry I was tired

    Forms("Parts_form")("All_Parts").Form("Child0").Re cordSource = partsList & "_tmp"

  5. #5
    Join Date
    Oct 2002
    Posts
    15

    Argghh!!

    Ok, new error message...

    Run-time error '438'

    Object doesn't support this property or method


    this is the code thats highlighted by the debugger

    Forms("Parts_form")("All_Parts").Form("Child0").Re cordSource = partsList & "_tmp"


    Thanks trying to help me, I really appreciate it
    -The enemy of good is better...

  6. #6
    Join Date
    Feb 2002
    Posts
    403
    Please zip and upload

  7. #7
    Join Date
    Oct 2002
    Posts
    15

    Thanks Dynamictiger

    Just disregard that email, I am uploading this correctly this time
    Attached Files Attached Files
    -The enemy of good is better...

  8. #8
    Join Date
    Feb 2002
    Posts
    403
    I am at work now. Will look at tonight, wont take long.

  9. #9
    Join Date
    Feb 2002
    Posts
    403
    Source object
    Attached Files Attached Files

  10. #10
    Join Date
    Oct 2002
    Posts
    15

    Smile Thank You!

    Thank You dynamictiger it works great now! I would've never guessed that Child0 didn't have a RecordSource property and instead had a SourceObject property. I am very pleased now as this gives me something to work with, I am finally no longer stuck, thank you very much.
    -The enemy of good is better...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •