VBA in Navigation form (1 Viewer)

I am trying to understand the navigation forms.

I have 2 forms [fromMemberDB] and [frmCases]

I have dragged and dropped these 2 forms into a Navigation form [frmMemberNav]and I can switch between the 2 with the tabs.
In [fromMemberDB] there is a field called "MemberID" and in [frmCases] there is one with the same Name "MemberID"

I need that the "MemberID" from [frmCases] equals the one from [fromMemberDB].

I need to place some VBA and the first question is where. In the NavigationSubform? Or is it in the actual texbox for the "MemberID" on the Navigation form?

I've tried different things with the code:
Me.MemberID=Forms![frmMemberNav]![NavigationSubform].[Form]![MemberID]

Would the right event to place it in be "Before Update"?


Can I get some help with this, please?

Personally I avoid the inbuilt navigation forms as they are a right royal pain to work with. They appear to load each tab as a subform on load, meaning you can't refer to the unloaded form easily, as it doesn't actually exist on the navigation form at that point in time.

Create you own form with the tabs on it, and load each form as a subform on the tabs. You can then refer to them in the normal way.

Minty said:

Personally I avoid the inbuilt navigation forms as they are a right royal pain to work with. They appear to load each tab as a subform on load, meaning you can't refer to the unloaded form easily, as it doesn't actually exist on the navigation form at that point in time.

Create you own form with the tabs on it, and load each form as a subform on the tabs. You can then refer to them in the normal way.

Click to expand...

Thanks!

When you say "Create you own form with the tabs on it", can I use the object Design>Navigation Control?

I still fail to refer to an object from tab to tab.

I have some members details with a MemberID in a tab and I need on a second tab to get the MemberID from the first one when I open it.. I can't really figure it out. :banghead:

No just create a normal blank form. Add a tab control.
Plonk one form on each tab.

In VBA tabs are simply page extensions of the form, they don't need referring to separately, simply refer to the subform container, or the form within it.

This page will probably help - bookmark it. http://www.access-programmers.co.uk/forums/showthread.php?t=225837

on the Main Navigation Form, add an unbound
textbox (txtMemberID). Set its visible property
to no.

click on the "MemberTab" where formMemberDB belongs.
click on the upper left corner of the subform.
click it again making sure you see the black dot marker
is inside.
add code to the Current Event and Load Event of the subform:


if memberid is numeric, remove the Chr(34) from the above code.

now click on the "Cases" tab of the navigation form.
select the "frmCases", by clicking the upper left corner
of the form. if not black marker is seen, click it again.

now add code to the Load Event of the:

(let say the recordsource of this subform is
"SELECT * From tblCases")


remove Chr(34) from the above if memberid is numeric.

that's it.