asked on

Switching from a subform on one tab, to a subform on another tab, finding a record

I have a form with a tab control. One tab contains a data entry single form for delivery dispatches. Another tab contains a continuous form that lists all the dispatches for an individual location, chosen by a combo box on that form. The continuous form has an object containing the dispatch id. The single form has a hidden text box containing the dispatch id. If I'm on the continuous form, on a particular record, how can I switch to the single form, displaying the dispatch corresponding to the current record on the continuous form?

Thank you

Gustav Brock

Though not two continuous subforms, this article may help you:

Synchronizing Multiple Subforms in Access

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Lobb

ASKER

Thanks for the feedback.

The first part is working. But on the line, 'Me.Parent!frm_Dispatch.Bookmark = .Bookmark', I get the error 'Object doesn't support this property or method'. Could this be that the record source of the single form is a query, using a few tables?

Dale Fye

Try:

Me.Parent!frm_Dispatch.form.Bookmark = .Bookmark

note that i added the reference to the "form" object between the subform control name (frm_Dispatch) and the .Bookmark property.

Dale

Tom Lobb

ASKER

That did it. Thanks very much.

Dale Fye

Don't forget to close out your question.

Tom Lobb

ASKER

Thanks for the help

Dale Fye

glad to help