A
Apprentice
I have a tabbed form with 3 different forms, from 3 different record sources
(tables). Each table has a common field [Project_ID]. The 3 tables have a
relationship set to one-to-many on the [Project_ID]. Table 1 being (one) and
the other two tables being the (many... foreign key)
I also have a lookup form: ProjectLookup, combo box (Combo32) that pulls a
query of the Activities that are in the Activity Main Table. The user
selects the [Project_ID], that opens the Tabbed Form with the selected
Activity already loaded in the form.
FIRST:..... I can't seem to get the "After Update" code to open the Tabbed
Form to the selected record identified in the combo box (Combo32) of the
"Lookup Form" when using a WHERE condition. I believe it may be because I
have missed named the controls do to the Tabbed Form. I'm using a Macro, and
maybe I should be using code? Here are the details.
LookUp Form Name: ProjectLookup..... Unbound Field= Project_ID... from
ProjectTable Query
Tabbed Form Name: ProjectMonitor
1st Form name: ProjectHeader Table 1: [Project_ID] = Primary Key
2nd From: ProjectActivities Table 2: [Project_ID] = Foreign Key
3rd Form: Project Table 3: [Project_ID]= Foreign Key
macro: Open Form:
ProjectMonitor.....Where("[Forms]![ProjectMonitor]![ProjectActivities].[Form]![Project_ID]= Forms![ProjectLookup]![Combo32]")
No success.
Second:..... I have been playing with setting "Link Master and Link Child"
between the three forms using the [Project_ID]. I need the form to stay on
the record selected from the ProjectLookup Form throughout the user's
session. No navigation ability etc.
But still can't get that to work either......
Help! What am I doing wrong? I need to remove all the actions I have tried
so desperately to make work and start with a systematic path to set this up.
(tables). Each table has a common field [Project_ID]. The 3 tables have a
relationship set to one-to-many on the [Project_ID]. Table 1 being (one) and
the other two tables being the (many... foreign key)
I also have a lookup form: ProjectLookup, combo box (Combo32) that pulls a
query of the Activities that are in the Activity Main Table. The user
selects the [Project_ID], that opens the Tabbed Form with the selected
Activity already loaded in the form.
FIRST:..... I can't seem to get the "After Update" code to open the Tabbed
Form to the selected record identified in the combo box (Combo32) of the
"Lookup Form" when using a WHERE condition. I believe it may be because I
have missed named the controls do to the Tabbed Form. I'm using a Macro, and
maybe I should be using code? Here are the details.
LookUp Form Name: ProjectLookup..... Unbound Field= Project_ID... from
ProjectTable Query
Tabbed Form Name: ProjectMonitor
1st Form name: ProjectHeader Table 1: [Project_ID] = Primary Key
2nd From: ProjectActivities Table 2: [Project_ID] = Foreign Key
3rd Form: Project Table 3: [Project_ID]= Foreign Key
macro: Open Form:
ProjectMonitor.....Where("[Forms]![ProjectMonitor]![ProjectActivities].[Form]![Project_ID]= Forms![ProjectLookup]![Combo32]")
No success.
Second:..... I have been playing with setting "Link Master and Link Child"
between the three forms using the [Project_ID]. I need the form to stay on
the record selected from the ProjectLookup Form throughout the user's
session. No navigation ability etc.
But still can't get that to work either......
Help! What am I doing wrong? I need to remove all the actions I have tried
so desperately to make work and start with a systematic path to set this up.