Select a field in a row and display data

[Darkladymelz]

I have a report that contains a list of tenants and their reference numbers and booking information. Is there a way of clicking on a reference number and it displaying a new report or form containing any information related to that particular reference number.

Also I would like the same kind of thing in relation to email addresses. I would like to be able to click on an email address and it open Microsoft outlook and it display the email address in the "To:" field.

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/wherecondition.htm

You can use SendObject for the email.

[Darkladymelz]

Is this what you're after?

http://www.baldyweb.com/wherecondition.htm

You can use SendObject for the email.

I think this is exactly what I am looking for but I am finding it difficult to understand. If I send you a dummy version of my database would you be able to give me a working example?

[pbaldy]

You can post it here, but it's pretty simple. You just have to replace the 3 names with yours.

[Darkladymelz]

Find attached a dummy version of my database.

If you open the 'Active Landlords' report you will see the first column is the Landlord Reference numbers. I would like to be able to click on an individual record and it open up a report or form with the properties that are associated with that particular landlord reference.

If you are able to show me a working example of this, i think this will help me to have a better understanding of it.

Thanking you for taking your time to help me with this.

[pbaldy]

Open which report or form? It would look like:

DoCmd.OpenForm "Landlord Details", , , "[Landlord Ref] = '" & Me.Landlord_Ref & "'"

[Darkladymelz]

I tried this but it came back with an error message.

I want it to open up a new report with just that information in it.

[pbaldy]

Well, I tested that in the double click event of the field in your report and it worked correctly. No knowing exactly what you tried, or what the error message you got was, I can't say what might be wrong.

[Darkladymelz]

Can you send me the database back with what you did? Maybe I can see where I went wrong?

[pbaldy]

Here you go.

[Darkladymelz]

I have tried to do the same as what you have done but have replaced the name of form to open. I keep getting this error message



I have attached my database, if you could please let me know what I have done wrong. The Report is Active Landlords, and I want to be able to click on the Reference number and the the form 'Find Landlord_Properties' should open with the landlord details I selected displayed.

[pbaldy]

I'm on an iPad right now so can't look at th db. Is the code in the properties window or the code editor where it should be?

http://www.baldyweb.com/FirstVBA.htm

[Darkladymelz]

Yes I have it in the dbl click section.

[pbaldy]

It's that SQL above. Delete it or comment it out:

'SELECT Surname
'FROM Active_Landlords
'ORDER BY Surname))

[Darkladymelz]

AH!! YES!!! I deleted it.

Thank you so much for your help.

How would I use this code to open Microsoft Outlook if I click on an e-mail address? Is there something different I have to write?