open a record for editing on click

[blueanchor]

from a list of records showing limited information how can i open a record on clicking on it to show all information

 

[blueanchor]

Problem solved

 

[dragginthru]

would you mind sharing what you did?

I came up with one way of making data "editable" ie just have it in labels on form A (read only, effectively) and then form B is virtually the same but uses text boxes. If theres another way i'd be interested!!!

 

[blueanchor]

When you creat a event procedure on click or double click
add the following :

Dim strFormNAme As String
Dim strCriteria As String

strCriteria ="[yourcell name ] =' " & Me! [yourcell name] & " ' "
strFormName = "Your form name to open"

Docmd.openform strFormName, , , strCriteria, , acDialog


Hope this helps

 

[neileg]

You can set the Allow Edits property of the form through code, ditto Allow Addittions, Allow Deletions. A command button that toggles the Allow Edits property should do what you want.