On click macro from datasheet subform

[DanT]

Hi there, I'm trying to set up 'on double click' macro fired from subform that is in datasheet mode. The main form is contact manager with title header, 'add new' button and a list of all existing contacts as a subform in datasheet view. I want to open particular contact in separate form by double clicking on it. I managed to set this up working well when the embedded list is opened as a separate datasheet form but when using the main form, program asks me to manually enter ContactID value. Any idea how can I make this work? I really like datasheet representation as it has all the filtering options built in.

[Bob Fitz]

Can you post a copy of the db, even with no records or just a couple of fictitious records

[ranman256]

Put the macro in a button on the master form.

[DanT]

Hi Bob, my database is SQL backended so I'm affraid it won't work. I made a screen shot for you though. I work on real life data so had to delete a chunk of it but you should get an idea what's going on

[Bob Fitz]

Put a textbox in the Header of the main form. Call it txtID Set its Visible property to No. Set its Control Source property to =[NameOfMainForm].[Form]![ID]
Substitute NameOfMainForm with the name of your main form. Be sure to include the "="

Set the where condition of your macro to: [ID]=[Forms]![NameOfMainForm]![txtID]
Substitute NameOfMainForm with the name of your main form.

Like many members here, I use VBA code rather than macros but I've tried this and it seems to work for me. I hope it does for you too but post back if you need to.

[DanT]

I took a couple of tweaks but works like a charm. Thank you very much Bob!

[Bob Fitz]

I took a couple of tweaks but works like a charm. Thank you very much Bob!

Always glad to help if I can.

What tweaks were needed?

[DanT]

Always glad to help if I can.

What tweaks were needed?

Just to adjust the code to my naming structure, the idea itself is immaculate