Select Row Only

[id1234]

I have a split form and I want to only allow data to be changed in the form and not on the Datasheet so I set the Split Form Datasheet property to Read Only. However, is it also possible to set the datasheet so when I select a record it selects the entire row rather then selecting the field that I clicked within the row?

 

[highandwild]

Seeing as you do not need to change any date in the datasheet, you could use a listbox and then when you clicked on the row the entire row would be selected.

Why do you want the entire row highlighted?

 

[id1234]

The Recordsource for the for is derived from a search query that pulls only the records that are needed. In this case the records are Scorecard. The form may be all scorecards for a certian person. The Datasheet portion is meant to just be a list of the records retrieved and then when you select one of the rows it populated the fields on the form.

 

[highandwild]

Then a listbox would do the trick.

You can change the row source on the fly and requery it.

When you say repopulate the form do you mean just find the corresponding record and display it?

Do you want to move to other form records using the record navigation buttons. If not then you can use a filter on the main form when the listbox is selected. If so then just find the record.

 

[id1234]

Unfortunatly a listbox won't work because some of the fields returned require a lookup value and as far as I can see a Listbox won't do that for individual columns.

 

[boblarson]

Unfortunatly a listbox won't work because some of the fields returned require a lookup value and as far as I can see a Listbox won't do that for individual columns.

1. I hope you don't mean that you are using lookups at table level.

2. You use a QUERY not a table for the source so you can use the query to provide the value that matches the other table (hence the lookup).