Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    91

    Question Unanswered: Loading searched data in a form

    Hi guys, am new in developing with Ms Access

    I use Access 2003. I've got a search screen which is working perfectly fine. now i wanna load the data that's = to the search criteria but i want it in another (seperate) screen

    Can u please kindly help as to how can i do that

    1st screen (Search screen) contains 3 textboxes (customername, customersnumber and repname) which i search by

    2screen (where i wanna load the data) i want it to contain everything it get regarding that search criteria. Please let me know if there r any Qs

    Thanks
    Noks

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello Noks!

    Look at Access Help "OpenForm Method".
    DoCmd.OpenForm formName,view,filterName, wherecondition .......

    I think you can solve your problem with wherecondition.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by MStef-ZG
    Look at Access Help "OpenForm Method".
    DoCmd.OpenForm formName,view,filterName, wherecondition .......

    I think you can solve your problem with wherecondition.
    What? No demo? Slipping up in your old age ...
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello M Owen!

    No Demo today, I have no time to invent the data every day.

Posting Permissions

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