I would like to view multiple records at a time on one form. I was thinking of doing a datasheet format for the form(rather than the columnar format I've been doing which displays one record at a time).

Here's the question. Is there a way within the form to be able to double-click on one of the records in the datasheet format and have it open up another form with that record that you clicked on? Would this require alot of programming? (not my speciality).

I basically have a Trouble Ticket Database which the customers use to report problems. I'd like the techinical support to be able to open a form and at a glance see a summary of the open tickets and then if they want more detail to be able to double click on one of the records and have it open up that record in it's own form for easier viewing/editing. I have 2 tables "users" and "tickets" the primary key is "LANID" in the Users table and it's linked to the LANID in the Tickets table, although LANID is not unique in the Tickets table. Not sure if all that's relevant but it gives an idea to what I'm doing. As always your help is appreciated! Thanks in advance.

Amy

Hey I got this to work without writing any code! I totally cheated. Used the wizard to create a command button to open the form based on certain matches. Then I copied the code from the command button and put it on the double click event of the text box. Bottom line is it works. Amazing!

Amy