multiple items form- click a row

[orelv4]

hi,
I have a multiple items form from a table of projects.
each row is a project record, I need the user click on a row and a form of the clicked project will be opened.
Is there any way to do it?
because I know asp.net it has datagrid -I can click rows and open forms with parameter transfered from the clicked row.

 

[SOS]

I usually put a double click event on the text box which has the ID for the record and then it is:

DoCmd.OpenForm "FormNameHere", acNormal, , [IDFieldNameHere]=" & Me!IDFieldNameOnMyFormOpeningFrom

 

[orelv4]

somehow, I write a code and save it and I belive the form ignore it
design view -> tools ->view code
and than I write it in a VB

Private Sub Pro_ID_DblClick(Cancel As Integer)
Me!Pro_Status.Visible = False
End Sub

 

[orelv4]

ok the im in the code thanks!!!
but I have problem with the syntax:

DoCmd.OpenForm "Form_projects", acNormal, , "[proj_ID] = Me!proj_ID"

do u see the problem?

 

[SOS]

Yep, try this instead:

If proj_ID is numeric:

DoCmd.OpenForm "Form_projects", acNormal, , "[proj_ID] = [COLOR=red][B]" &[/B][/COLOR] Me!proj_ID

If proj_ID is text:

DoCmd.OpenForm "Form_projects", acNormal, , "[proj_ID] = [COLOR=red][B]" & Chr(34)[/B][/COLOR] Me!proj_ID [COLOR=red][B]& Chr(34)[/B][/COLOR]

 

[orelv4]

thanks!
but it still not working...
what I want to do is when the user click on a row he will transfered to the Form_projects form which he will get there more details for the specific project he clicked on
the Form_projects form is source from the projects table.
so maybe the problem is here?

 

[orelv4]

ok it works I used a macro open form :

[proj_ID]=[Forms]![form_projects]![proj_ID]