Creating an expression to pull a particular record

[sarchie]

I have a form which contains milestones and I have a separate table for
progress notes. I would like for the user to be able to select the milestone
for review and than on that same form select a command button to pull up the
corresponding progress note.

Currently, I have a query attached to the command buttom and it requests the
parameter value but I was trying to find another way to do this same action
without the request for a parameter value.

 

[sarchie]

Do I need to clarify my questions?

 

[Steve Schapel]

Sarchie,

One common approach to this type of scenario, is to make a form based on
the Progress Notes table, and then place that form onto the Milestones
form as a Subform. You set the Link Master Fields and Link Child Fields
properties of the subform to the field that links the 2 sets of data
together (maybe it's a MilestoneID or some such, or else what field do
you have in the Progress Notes table that identifies which Milestone the
notes apply to?). So then, when you move from record to record on the
Milestones form, the corresponding progress notes will automatically be
shown on the subform.

 

[John W. Vinson]

Do I need to clarify my questions?

You do need to have a little patience. These newsgroups are staffed by unpaid
volunteers, not by Microsoft tech support. An hour is pretty typical response
time, depending on who's browsing the groups and how busy we are.

Why not use a Subform for the progress notes? If you use the milestone ID as
the master/child link field, you'll see all the notes for that milestone on
the subform and can search or browse through them.

John W. Vinson [MVP]

 

[sarchie via AccessMonster.com]

I apologize Mr. Vinson. I am new to the discussion groups and used the
previous postings to get an idea of the response time to questions.

Do I need to clarify my questions?

[quoted text clipped - 6 lines]
You do need to have a little patience. These newsgroups are staffed by unpaid
volunteers, not by Microsoft tech support. An hour is pretty typical response
time, depending on who's browsing the groups and how busy we are.

Why not use a Subform for the progress notes? If you use the milestone ID as
the master/child link field, you'll see all the notes for that milestone on
the subform and can search or browse through them.

John W. Vinson [MVP]

 

[sarchie via AccessMonster.com]

Thanks for the suggestion, I will try it and get back to the thread.

Sarchie,

One common approach to this type of scenario, is to make a form based on
the Progress Notes table, and then place that form onto the Milestones
form as a Subform. You set the Link Master Fields and Link Child Fields
properties of the subform to the field that links the 2 sets of data
together (maybe it's a MilestoneID or some such, or else what field do
you have in the Progress Notes table that identifies which Milestone the
notes apply to?). So then, when you move from record to record on the
Milestones form, the corresponding progress notes will automatically be
shown on the subform.

I have a form which contains milestones and I have a separate table for
progress notes. I would like for the user to be able to select the milestone

[quoted text clipped - 4 lines]

parameter value but I was trying to find another way to do this same action
without the request for a parameter value.