AnnaHansen
Thread Starter
- Joined
- Jan 13, 2015
- Messages
- 4
Hello,
I have a subform that is supposed to display query results. The query is based on the order# field in the parent form and returns relevant details. When I open the form, and when I navigate to the next record, I am getting dialog boxes asking me for the value of the order#. After I populate the boxes it displays fine.
Both the parent form and the subform are set to Data Entry = No
I used expression builder when I set up the query to eliminate the chance of typos.
I am guessing that this is basically because the query is trying to run before the order# field has been populated when the form loads.
I have thought of a couple ways around this, one being a dialog box that asks you what order# you want to view before loading the form, and another being to move the order details to a separate form all together.
The problem with those options is that it has been specifically requested that entering new orders, viewing old orders, and viewing order details be all on the same form.
Is there some way around this so that the subform will populate on it's own properly both when the form is opened, and after navigating to another record?
I have a subform that is supposed to display query results. The query is based on the order# field in the parent form and returns relevant details. When I open the form, and when I navigate to the next record, I am getting dialog boxes asking me for the value of the order#. After I populate the boxes it displays fine.
Both the parent form and the subform are set to Data Entry = No
I used expression builder when I set up the query to eliminate the chance of typos.
I am guessing that this is basically because the query is trying to run before the order# field has been populated when the form loads.
I have thought of a couple ways around this, one being a dialog box that asks you what order# you want to view before loading the form, and another being to move the order details to a separate form all together.
The problem with those options is that it has been specifically requested that entering new orders, viewing old orders, and viewing order details be all on the same form.
Is there some way around this so that the subform will populate on it's own properly both when the form is opened, and after navigating to another record?