Continuous Form - Select Record

[debbieg]

I have a form with a subform in it. The subform is a continuous form.

The subform has a combobox for the user to select a record and there is an Add button for them to add a record. There is also a Delete button to delete an existing record. The Add and Delete buttons are functioning great.

The fields in the detail section of the subform are not enabled and locked because I don't want users to edit the data. The user has to click the Record Selector button in order to select a record.

Here's my question: I would like the user to be able to select a record by clicking anywhere in the record.

I've tried putting DoCmd.RunCommand acCmdSelectRecord in the On Click event in the Detail Section and that doesn't do it. I've tried putting a transparent rectangle over all of my detail fields and setting it's On Click event but that doesn't do it.

Any suggestions?

Thanks,
Debbie

 

[seaport]

Debbie,

As far as I know, in a continuous form, you select a record by clicking anywhere in the record. So you do not need to write any code. Am I missing anything?

Seaport

 

[debbieg]

It won't do it because all the fields are not enabled and locked.

The only thing the user can do in this field is add or delete. If they want to edit, they do that in another form.

 

[seaport]

Do you have to disabled all fields in the form? Can you just lock them but not disable them?

Or, just create a very big command button "Select". No code is needed for it.

Seaport