Can This Be Done

[extreme]

Can this be done I have a sub form named SiteSurveySub is there a way to click on the infornation and open a new form

Can someone please help with this

Picture Attached

 

[Oldsoftboss]

Does the Subform record source have a primary key (ID) (I presume so). If so, create a normal form based on the same record source, then on the subform double click event:

Dim rs as Object

Docmd.OpenForm "YourFormName"
Set rs = Forms!YourFormName.Recordsource.clone
rs.findfirst "IDFieldName = " & me.IDFieldName
Forms!YourFormName.Bookmark = rs.Bookmark


Dave

 

[extreme]

Thanks for the reply

I have done what you said and I'm getting this error
can you please explain

Thanks

Pic attached

 

[KeithG]

try this instead

Forms!YourFormName.Form.Recordsource.clone

 

[extreme]

try this instead

Forms!YourFormName.Form.Recordsource.clone

Still not working any other suggestions

 

[Oldsoftboss]

What I posted is what I used on all my Db's, so you might try checking references etc. Apart from that, try puting the code in the DOUBLECLICK event of one of the fields. Make sure the forms name is correctly spelt also.

Dave

 

[KeithG]

What is the actual error?

 

[extreme]

What I posted is what I used on all my Db's, so you might try checking references etc. Apart from that, not sure

Thanks for your time I will give it a try

 

[KenHigg]

Not sure if I'm missing something here but I'd just put a small button on the row(s) and have them click it...

???
ken

 

[extreme]

What is the actual error?

I keep getting this error picture attached

 

[KeithG]

no error message?