linking subforms by a specific value

[kkrizl]

I have a form that shows burglar alarm permits. I have a subform that
shows the alarms that have occurred at the location of the permit
(linked by permit number). There is a different fine schedule for false
alarms for burglar alarms vs. panic alarms. I thought I could just
create an alarm type field and add an additional subform so that
burglar alarms appear in the first subform, and panic alarms appear in
the second subform. I tried filtering the subforms by alarm type, but
I couldn't get the filter to save. I tried having the subforms based
on queries that separate the alarm types, but I had problems defaulting
the alarm types when adding new entries. I'm now thinking about
creating two separate alarm files, but then I'll have to update a bunch
of other stuff. What would be the best approach, and how can I get it
to work?

[David Lloyd]

You could use the Link Child Fields and Link Master Fields properties of the
subform to filter based on alarm type, and any other filter properties.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"kkrizl" <kk****@co.el-dorado.ca.us> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
I have a form that shows burglar alarm permits. I have a subform that
shows the alarms that have occurred at the location of the permit
(linked by permit number). There is a different fine schedule for false
alarms for burglar alarms vs. panic alarms. I thought I could just
create an alarm type field and add an additional subform so that
burglar alarms appear in the first subform, and panic alarms appear in
the second subform. I tried filtering the subforms by alarm type, but
I couldn't get the filter to save. I tried having the subforms based
on queries that separate the alarm types, but I had problems defaulting
the alarm types when adding new entries. I'm now thinking about
creating two separate alarm files, but then I'll have to update a bunch
of other stuff. What would be the best approach, and how can I get it
to work?

[kkrizl]

The Link Child Fields and Link Master Fields properties of the
subform are set to the fields that link them already (permit number in
both tables). I know I can specify additional fields by separating
them with semicolins, but what is the syntax to specify a value for the
field to be filtered by?

[Bob Quintal]

"kkrizl" <kk****@co.el-dorado.ca.us> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:

I have a form that shows burglar alarm permits. I have a
subform that shows the alarms that have occurred at the
location of the permit (linked by permit number). There is a
different fine schedule for false alarms for burglar alarms
vs. panic alarms. I thought I could just create an alarm type
field and add an additional subform so that burglar alarms
appear in the first subform, and panic alarms appear in the
second subform. I tried filtering the subforms by alarm type,
but I couldn't get the filter to save.
Even if you had, you would have encountered the problem of what
you tried next.

I tried having the subforms based on queries that separate the alarm types, but I
had problems defaulting the alarm types when adding new
entries.
But you didn't set each subform's alarmtype.defau ltvalue.
I'm now thinking about creating two separate alarm
files, but then I'll have to update a bunch of other stuff.
This would not be a smart move. both for maintenance and what if
you add a third alarm type.
What would be the best approach, and how can I get it to work?

I can suggest two options:
1) create a new table, containing alarmtype.ID and
Alarmtype.descr iption. On the single subform, add a combobox for
the alarmtype, so that it's easy to identify and change
alarmtypeid.

2)On your mainform, add hidden textboxes, each containg the
value of one alarm type. Set the link child fields to
permitnumber;al armtype and the link parent fields to the
permitnumber;na meoftextbox containing the alarmtype value you
want in that subform.

--
Bob Quintal

PA is y I've altered my email address.

[kkrizl]

I used option 2, and it works great.
Thanks!

[Larry Linson]

LinkMasterField s and LinkChildFields must match for the Record to display in
the Form embedded in the Subform Control. Those properties _are_ a kind of
filtering. They are not as flexible as a WHERE Clause.

Larry Linson
Microsoft Access MVP

"kkrizl" <kk****@co.el-dorado.ca.us> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

The Link Child Fields and Link Master Fields properties of the
subform are set to the fields that link them already (permit number in
both tables). I know I can specify additional fields by separating
them with semicolins, but what is the syntax to specify a value for the
field to be filtered by?