Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Location
    UK
    Posts
    4

    Unhappy Unanswered: retrieve info from previous form

    im trying to make a form so that when somebody clicks on a part number it open s a new form displaying the new information on a seperate form.
    but everytime i try and do it, it keeps asking me for the part number.

    the new form i built from a query and i entered in the Criteria column of the part number to retrieve the information from the previous form and relay the info onto the new form.

    [Forms]![Form Name]![Field Name]

    but it doesn't seem to be looking up the information, all's it keeps on doing is prompting me for a part number which is not what im trying to achieve.

    please help

  2. #2
    Join Date
    Aug 2002
    Location
    Melbourne, Australia
    Posts
    111
    Is the part number and new information from the same table?

    If not, what relationship is there between the 2 tables?


    Or post a sample of your db and someone may be able to help


    Regards,
    Regards,



    John A

  3. #3
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Just to clarify is the part Number field populated when the other form is opened or it it blank?

    Disclaimer: This is my first thought being less experienced than others.

    Check for a typo. Sounds silly but I know I do this all the time. sometimes I will have field then as for fields. Silly me.

    If the Field is blank or NULL then the Query is going to ask for the number since it has no Number to pull from the form.

    Is the record being saved? If I type into a field on a form that value is not saved until I exit that field by clicking another field or a button or what have you.

    Probally not useful information just the things I would look at first.
    Darasen

  4. #4
    Join Date
    Sep 2004
    Location
    UK
    Posts
    4
    it's ok now, i managed to fix the problem.

    it turns out that because the field i was referring to was a subform i needed to refer to the main form and then refer to the sub form.

    thanks for the help anyway

Posting Permissions

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