General discussion

Locked

MS Access - DoCmd.GoToRecord

By NetMan_OVO ·
I have a Form Frm_Sub_Transaction_List & the below code word fine

DoCmd.GoToRecord acDataForm, "Frm_Sub_Transaction_List", acGoTo, Rec_No

But when I attach Frm_Sub_Transaction_List to Frm_Main_Transaction_List the code does not work

Can anyone help...
Thanks

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MS Access - DoCmd.GoToRecord

by donq In reply to MS Access - DoCmd.GoToRec ...

You need a commom field ([Rec No]) in the Parent + Child Form. Base your sub-forms Record Source property on a query containing the common field and enter "[Forms].[Main Transaction List].[Rec No]" (without the quotes) in the sub forms Criteria Field under Rec No.

Collapse -

MS Access - DoCmd.GoToRecord

by NetMan_OVO In reply to MS Access - DoCmd.GoToRec ...

Poster rated this answer

Collapse -

MS Access - DoCmd.GoToRecord

by NetMan_OVO In reply to MS Access - DoCmd.GoToRec ...

Poster rated this answer

Collapse -

MS Access - DoCmd.GoToRecord

by NetMan_OVO In reply to MS Access - DoCmd.GoToRec ...

This question was closed by the author

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums