How to View the Selected Order on a Form

[angus macgyver]

This thread was a continuation of form not updating table--changing the control source of a field. The database in question is discussed there and the latest attached version can be found at customers.zip.

The problems I have are:

1. Viewing an order using the view order button in the form formorderslist.
2. Listing the orders in the form formorderslist by order date.

Any ideas would be greatly appreciated as always! I think these 2 issues solved would result in an easy to use database don't you?

Fred.

[NeoPa]

Let's see if we can throw some more points at you.

1. It's never a good idea to identify a record by its name. You already have the associated ID. Use that to filter [FormOrdersList]. If you don't already have it as a hidden column in the relevant ComboBox then update it to include that and use it in the WhereCondition parameter of the OpenForm() call.
2. Your code for bvieworder_Click() is :
   

   Private Sub bvieworder_Click()
   On Error GoTo Err_bvieworder_Click
    
       Dim stDocName As String
       Dim stLinkCriteria As String
    
       If IsNull(Me!orderid) Then
           MsgBox ("Choose another order")
           GoTo Exit_bvieworder_Click
       End If
    
    
       stDocName = "formorder"
    
       stLinkCriteria = "[orderid]=" & "'" & Me![orderid] & "'"
       DoCmd.OpenForm stDocName, , , stLinkCriteria
    
   Exit_bvieworder_Click:
       Exit Sub
    
   Err_bvieworder_Click:
       MsgBox Err.Description
       Resume Exit_bvieworder_Click
    
   End Sub

   [OrderID] is a numerical value so the quotes in line #15 are causing a problem. Try instead :
   

       stLinkCriteria = "([orderid]=" & Me.orderid & ")"

   Parentheses aren't absolutely required but they can help to avoid confusion.
3. To sort the orders by date simply enter [OrderDate] into the form's Order By property.

Let us know how you get on with these :-)

[angus macgyver]

NeoPa,
you've done it again. thank you for so clearly providing solutions to the problems presented heretofore!
#s 2 and 3 solved the biggest issues. now i can choose a specific event on the continuous form and the events of said form are sorted in order! i am unsure where suggestion #1 fits in but i will look into it....

the database finally seems workable! alas a few issues remain (albeit minor ones) which i believe will warrant a new thread. the saga continues....

[NeoPa]

Yes, a new thread is always a good idea (but feel free to link me to it from here if you like).

Having two (even small) questions in a single thread can cause issues. I found the thread deleted at one stage as an admin deleted it for a poor title - that I'd set up!

Finding a suitable title to cover two different questions wasn't easy, but I put something together eventually. Anyway, 1 question 1 thread will ensure it's all much more straightforward in future. It also means that a single post can be selected as the Best Answer when the question has been satisfactorily answered.