Query to Form

[Sharkun]

Been working on a small service ticket program for our company to use in house. Got my form working good and I like what it can do for us.

The one thing I'm curious about is:

We enter tickets and have one "Yes/No" value if the ticket has been closed. I've got a query to show my the tickets that are not closed. Is there some way I could select one of the query values and propagate that into my service ticket form?



I see how to do a query by form, but wanting to know if there is something I can do find/edit those open tickets easier.

Thanks

[Sharkun]

Figured out how to show the query on my form.

Two questions

1. On the query combo box showing my open orders. I would like to click on a particular entry and have the form update with that ticket's data. When I try to make a simple line code of
>>
Private Sub List67_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
List67.Value = Text69.Value
End Sub
<<
Text69 being the ticket ID number generated by access. When I try to do this I get:
>>
Run-time error '2448'

You can't assign a value to this object.
<<

2. If using the query I have in question 1, I open a ticket that is listed there. Let's say I close that ticket out, but it still shows up in the query. I would assume there is a code I could attach w/ the "Save Record" button to have the query combo box be refreshed.

Thanks