Trying to make (complicated?) user interface in form.

[theundergod]

I am not sure how to explain this but I will try as hard as I can. I have a table that has several columns of information, of course. I can obviously use a datasheet view and create a form that lists everything in an easy to read list. what I am trying to do however is make these listed records click-able so that when someone doubleclicks on the record they can edit and/or see extra information on a bigger form that presents the information differently. I know how to set it up so there is a button to the side of the record that allows this to happen but I would like the whole record to be selectable indstead of just putting the cursor in one of the fields and pressing a seperate button. I hope this makes sense. I put this in the VBA section because I don't see a possible way of doing this without using VBA. If anyone has any suggestions on what to try that would be fantastic. I figure I will probably have to use a temporary table that consolidates all the information into a single column and then displays it in a form so that the original columns are not displayed seperately. Thanks again if anyone had the patience to read through this whole thing Please know I am not just sitting here waiting for someone to figure this out for me. I will still try to figure it out on my own but if you have any suggestions that would be awesome.

Thanks,
Jon

 

[PHV]

You may consider a ListBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BuilderSpec]

Hi

For each field across the row, add a Double-Click event that points to the same function..

Private Sub Name_DblClick(Cancel As Integer)
GeneralProc()
End Sub

Private Sub AddressLine1_DblClick(Cancel As Integer)
GeneralProc()
End Sub

Sub GeneralProc()
Bigger display code
End Sub

this way user can double click any field to process the record and display the bigger form

Hope this helps

BuilderSpec

 

[theundergod]

I appreciate the suggestions. I am trying to make a more sleak interface though so that the entire record as a whole can be selected, and highlighted, for easier viewing and then double-clicked to open if wanted. The suggestions offered will work just not the way I am looking for. Thanks again for the time you took to reply and help me out.

Jon