Access 2000 Bug or What?

[juddshanker]

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.

 

[kbstoikop]

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