Linking?

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

Guest

Hi All, I am having a problem at my form, when I open my weekly form and from
there open my weekly adv form they are open all data from my study. For
example I am at STUDY1 and open a WEEKLY form for that on WEEK2, it carries
the info I need, but when I open the form WEEKLYADV for WEEK2 to see what ad
I did that week it shows me all info for that study and all weeks (I have up
to 52 weeks, so I dont want the user go all the weeks to find the week they
are working on it)? It is a linking problem, or do I have to use filter? My
WEEKLYADV is a subform is a single form on the form parent. Thanks in advance
 
"from there open my weekly adv form " - How do you open the form? Is it in
code? Is the form based on a query?
 
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
 
Please help me!!!I open from my weekly form, has a command that open my
WEEKLY AD form, but the subform is bringing since week 1. If I am in week 21,
I want to use that week. I have been trying for 2 days, I was trying to see
if was a linking or filter. Please I am frustared. Tia
 
Back
Top