ListBox to Display Subform

[djkay2637]

OK Here goes! I will try and explain what I want to achieve by using a customer / order database example. The database I am actually adapting is a collage faculty ILP database but I think the customer/order database would be easier to explain.

So I have a Customer form and an Order Subform within the Customer form. Within the Order Subform I can have many orders. When I load another customer's record, I can see only those orders for that customer. Great that works as I would expect. What I want to do is have a listbox that lists all the dates that customer has placed an order and when I double click onto that date within the listBox I want that specific Order Form to load in the subform. The reason i don't want this to be a simple report is because i want to be able to update some values in that specific Subform if that makes sense.
Any ideas as to how this could be done?

Thank you in advance.

Regards
Dan

 

[theDBguy]

Hi,


Let me see if I understand. You have a customer form showing his or her orders in a subform. Assuming the subform is showing more than one order at a time, when you select a date from the listbox, are you saying you want to see "all" the orders created on that date? If so, look into "filtering" the subform based on the date selected from the listbox.


Hope it helps...

 

[djkay2637]

Thank you for spending the time to reply. In answer, not quite. You can only see one order at a time in the subform as it is quite large. By default I want it to load the most recent however, if there are more orders that that specific customer has made, i want the system to list all other orders in a listbox next to the subform. By double clicking on that order's date within the listbox will load that record in the subform.

Hope that clears things up.

 

[theDBguy]

Hi,


I think there are two ways to display the order in the subform: (1) filter it, or (2) navigate to the selected order. I am hoping each order has a primary key field to uniquely identify each one, so you can easily find what the user selects. As for displaying the matching orders in a listbox, it would be similar to a cascading combobox. There are some tutorials available online on how to create a cascading combo/listbox. Basically, when the user selects and item from the first listbox, it auto-adjusts the second listbox.