Help on Linking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a help for a linking problem I think.
I am working with 3 tables
PROTO
AD
WEEK
I have a FORM_PROTO that has details and I put a command button to open a
FORM_WEEK that shows me details of that Proto(Proto ID is linking) and
another command buttom that opens FORM_AD details on that week.
For Example, If I am on TEST2, WEEK 2 the FORM_AD opens on PROTO TEST2(ok)
but the week details shows all records, as for all weeks. I don't want my
user go to all records for all weeks(It can have 52 weeks). I want to bring
the info of the week that he is working on it. I did open form and did not
working. Please I need help. TIA
 
We need to know some more information. When the user clicks the command
button to show week details, what is being opened? Is it a query, or a
table, or a form, report, etc? If there is a control on the main form that
can be used as a filter, you could specify criteria in your query like this:

WHERE fieldweek = [Forms]![mainformname].[controlname]
 
Appreciated your attention, I opened a single form PROTOCOL (from table),
that displays me detays and I have a command button to open another single
form WEEKLY (from table) and a subform from that protocol that give me
details, (note that carry over the study name) and then I have another
command button (@subform) that opesn me other ADVERTISEMENT single form that
has a form carrying that study id and name and 2 subforms, one for that week
and other for advertisement.
For exemplo, I had a STUDYB, and on the week 6 I had some ads, so when I
opened ADVERTISEMENT birngs me STUDYB, but starting the week 1, and I dont
want the user see all this weeks, some studies I have up to 52 weeks. Should
I have a controling calendar, for 2 days I am trying so many options of
linking and filters, but not luck. When you mentioned WHERE, which control
should I put on??tia
 
Appreciated your attention, I opened a single form PROTOCOL (from table),
that displays me detays and I have a command button to open another single
form WEEKLY (from table) and a subform from that protocol that give me
details, (note that carry over the study name) and then I have another
command button (@subform) that opesn me other ADVERTISEMENT single form that
has a form carrying that study id and name and 2 subforms, one for that week
and other for advertisement.
For exemplo, I had a STUDYB, and on the week 6 I had some ads, so when I
opened ADVERTISEMENT birngs me STUDYB, but starting the week 1, and I dont
want the user see all this weeks, some studies I have up to 52 weeks. Should
I have a controling calendar, for 2 days I am trying so many options of
linking and filters, but not luck. When you mentioned WHERE, which control
should I put on??tia
 
Back
Top