Loading record in new form from subform

[riggsd]

I have a form with a datasheet subform and need to allow the user to select a row in the datasheet and then click on a button to load that record into a new form.

Since the subform is a datasheet, I can't put a button on it to load the item into the new form so I need to have the button on the main form, but have been unable to get it to work.

In the macro, the form to load is frmCoreCDRL where ="[CDRL_ID]=" & [CDRL_ID]. The subform name is frmFindCDRLsbyDID. Is there a way to add the subform name into the macro to tell it to load the record in frmCoreCDRL where CDRL_ID equals the CDRL_ID on frmFindCdRLsbyDID?

Thanks in advance.

 

[ranman256]

put cursor on record
click a button on the SUBFORM to edit it
in the ******* event of the button:

docmd.openform "frmCoreCDRL",,,"[id]=" & me.ID

 

[riggsd]

I can't add the button to the subform since it is a datasheet. I tried and even though it shows on the form in design view, it does not show up when embedded in the main form.

 

[apr pillai]

Yes, we can do this. But, explaining everything here is not possible.

First, how to run event procedures on datasheet? If you go through the following link you will have enough idea and required vba code to try out them:

Event Trapping Summary On Datasheet | LEARN MS-ACCESS TIPS AND TRICKS


You can double-click on a record (or use some other Event) on the datasheet to run an event procedure that can open a form with the current record on it. You can find the details of this trick on the link given below:

Synchronized Floating popup Form | LEARN MS-ACCESS TIPS AND TRICKS

Good luck.

 

[riggsd]

Thank you. I'll look as soon as I can. For some reason, the MsAccessTips.com site is not loading here at work. I've turned in a help desk ticket to figure out why.