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.
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.