1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2000 Bug or What?

Discussion in 'Business Applications' started by juddshanker, Jan 21, 2003.

Thread Status:
Not open for further replies.
  1. juddshanker

    juddshanker Thread Starter

    Joined:
    Jan 21, 2003
    Messages:
    1
    In its simplest form, I have a form named "Orders" which I normally start from a form named "Customers". The query in RecordSource for "Orders" uses controls from the form "Customers" to position at the correct "CustomerID" , "OrderID".

    Now, I want to start "Orders" from a form named "Products".

    I think all I need to do is to change the RecordSource in "Orders" Open event and everything should be ok, but between the time the OpenForm from "Products" and the OpenEvent on "Orders" I get a prompt for the parameters from the form "Customers" which is not open. Since the OpenEvent is 'supposed' to occur before anything to with data occurs, I think this is a bug, but, probably not one that will be fixed.

    In any event, I don't have another programatic solution, and I don't want to proliferate multiple versions of the form and the query. Any help will be much appreciated.
     
  2. kbstoikop

    kbstoikop

    Joined:
    Dec 13, 2002
    Messages:
    45
    sounds like your query has the is using the customers forms limiting the records.


    the simplest way is to get rid of the selectors in the query and select the records of the query in the form( the query should select all records)

    in access97 it would be done this way

    DoCmd.OpenForm "orders", acNormal, , [customerid] = Me.[customerid]

    put this code in the event procedure in the onclick comand of the button that you use to open your orders file

    of course you need customerid to be the name of the field on either customers or products form you are using to open the orders form and on the orders form itself
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/114518

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice