Displaying Records side by side as well as downwards.

[sargietek]

Is it possible to have a form's detail section list records side by side as well as downwards?

I have a User table containing 20 User records. I would like to list 10 records down the left hand side of the detail section & the next ten down the right hand side thus eliminating the need to use scrolling down the records to find the later ones. I can only think of using a table but don't know how to do this codewise, or by using a SQL select statement behind a search button to only return userName records that start with a letter entered by the user. Can anyone advise?

Best regards

Sargietek.

 

[CautionMP]

In a word, No.

If the form is only for 'navigating', i.e. no data updates will be done with the form, you can apply a filter to the records.

In the form header:
Create a Textbox named [tt]txtSearch[/tt]
Create a Command button named [tt]cmdSearch[/tt]

Add the following Event Procedure in the On Click event for [tt]cmdSearch[/tt]

Me.Filter = "userName LIKE '" & txtSearch & "*'"
Me.FilterOn = True

This will filter the records starting at the begining of the field [tt]userName[/tt]. If you want to do a 'full' text search use:

Me.Filter = "userName LIKE '*" & txtSearch & "*'"
Me.FilterOn = True

If you want to use non-linear data presentment (multiple columns) it can be done, but you will need to:[ol][li]Define all the controls (containers) you want to present on the form, in your example above, two rows of 10 controls.[/li][li]Write the code to connect to your recordset (linear data) and convert it to a non-linear format by applying record data to the structure created above..[/li][li]Define a scroll mechanism for this format[/li][li]If you want to allow the user to update infromation from here you will then need to write the code to identify the current record and update the data.[/li][/ol]
This will give you a snaking list similar to how the Contacts in Outlook behave. None of this is hard, just a lot of coding (and testing, and debugging...)

Hope this helps,
CMP

Instant programmer, just add coffee.