I want to do this without VBA, but rather use the Row Source property of the combobox.
I tried setting the "Row Source" property to the following but I get an error:
SELECT OrderID FROM myOrders WHERE (TicketNumber = Forms!ServiceTicket!TicketID)
I get the following error: Incorrect syntax near '!'
I also tried the following and got the same error:
SELECT OrderID FROM myOrders WHERE (TicketNumber = [Forms]![ServiceTicket]![TicketID])
The TicketID textbox is in the same form as the combobox.
Any ideas how I can get this to work?