Subform Nightmare..

S

Sonya

I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not let me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search].[Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
 
G

Guest

-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not let me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
What relationships do you have between your tables?
Click to expand...
 
P

Paul Falla

Sonya
It sounds like you have you have not got your child and
parent linkages quite right. Both subforms should link
back to the main form, that way it doesn't matter if you
have data entered in either the cell search or pat search
forms.

I hope this helps, we would not want you to stressing out
over the xmas period.

Kind regards
-----Original Message-----
-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not let me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
What relationships do you have between your tables?
Click to expand...
.
Click to expand...
 
P

Paul

Cand you tell me the relationships between your tables

they should be :-
inmateInfo 1-many inmate cell search
inmateInfo 1-many inmatepatsearch
-----Original Message-----
Sonya
It sounds like you have you have not got your child and
parent linkages quite right. Both subforms should link
back to the main form, that way it doesn't matter if you
have data entered in either the cell search or pat search
forms.

I hope this helps, we would not want you to stressing out
over the xmas period.

Kind regards
-----Original Message-----
-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not
Click to expand...
let
me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
What relationships do you have between your tables?
Click to expand...
.
Click to expand...
.
Click to expand...
 
S

Sonya

My relationship between the tables are
inmateInfo (inmate #) 1-many inmate cell search (inmate #)
inmate cell search (autonumber) 1-many inmatepatsearch
(inmate #) When I try to have inmateinfo 1-many for both
my subforms, I get the error msg: "You can not add or
change a record because a related record is required in
table "Inmate Cell Search""
Click to expand...
-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not let me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
Click to expand...
 
P

Paul

It wont work with a direct relationship between the two
sub form tables delete this relationship and the field in
Inmate Pat Search that enabled the relationship
what happens now?
you can email the database in zip form if you want
good luck
Paul
-----Original Message-----
My relationship between the tables are
inmateInfo (inmate #) 1-many inmate cell search (inmate #)
inmate cell search (autonumber) 1-many inmatepatsearch
(inmate #) When I try to have inmateinfo 1-many for both
my subforms, I get the error msg: "You can not add or
change a record because a related record is required in
table "Inmate Cell Search""
Click to expand...
-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not let me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
Click to expand...
.
Click to expand...
 
S

Sonya

I e-mailed you the databse in zip file. Thanks for your
help. Let me know if you did not receive or are having
trouble opening the datase. Again thank you.
-----Original Message-----
It wont work with a direct relationship between the two
sub form tables delete this relationship and the field in
Inmate Pat Search that enabled the relationship
what happens now?
you can email the database in zip form if you want
good luck
Paul
-----Original Message-----
My relationship between the tables are
inmateInfo (inmate #) 1-many inmate cell search (inmate #)
inmate cell search (autonumber) 1-many inmatepatsearch
(inmate #) When I try to have inmateinfo 1-many for both
my subforms, I get the error msg: "You can not add or
change a record because a related record is required in
table "Inmate Cell Search""
Click to expand...
-----Original Message-----
I hope someone can give me the answer to this problem. I
followed the instructions below and when I enter data in
the pat searches I get an error msg "You can not add or
change a record because a related record is required in
table "Inmate Cell Search"" Am I doing something wrong?

-----Original Message-----
open the main form in design view. then select the
subform control by
clicking on the border once. now open the properties
dialog and set the link
child field and link master field to the inmate id #, (
you can use the ...
build button at the rightmost side of either field
(child or master) to select the fields from a list. Do
this for both subforms and you will be able to enter data
relative to the inmate for each subform.
HTH

message Yes, that is what I want to do. Enter info in each of
my subforms concerning cell searches and/or pat searches
for each inmate. As of right now the form will not
Click to expand...
let
me
add pat searches unless I have data in the cell
searches, because the pat search info links to the cell
search info. Sorry this is so confusing.

-----Original Message-----
Dear Sonya

I am trying to understand what you are trying to
achieve here. Are you tryng to filter your 2 sub-forms
based on the pertinent information on your main form? EG
If Inmate#1 is active on the main form then Sub-Form1
should show the details of cell searches relating to
Inmate#1, and Sub-Form2 should show the the details of pat
searches
relating to Inmate#1.

If this is the case please post back and we will try
and help you further

Kind regards

Paul
-----Original Message-----
I am so stuck on this problem. I want my two subforms
to be connected to the main form. But when I enter
info in my 2nd subform, I can only see it if I go to the
corresponding line on the 1st subform. I want my
subforms to work independently. I also can't enter
info in my 2nd subform unless there is data in the 1st
subform. I hope I am explaining this right.
Thank you in advance for your help. Below is the
structure of my database....

Tbl 1: Inmate Info (Inmate #; Inmate Name)
Tbl 2: Inmate Cell Search (AutoNumber; Date Searched;
Inmate #; Inmate Name; Cellhouse; Cell; Bed; Reason;
U/A; Report; Staff; Start Time; Finish Time; Contraband
found)
Tbl 3: Inmate Pat Search (Date; Inmate #; Inmate
Name; Time; Staff; Location)

I can't find the SQL

Form 1: Inmate Info
record source: Inmate Info Table)

Subform 1: Inmate Cell Search Subform
record source: SELECT [Inmate Cell Search].[Auto
Number], [Inmate Cell Search].[Date Searched], [Inmate
Cell Search].[Inmate Number], [Inmate Cell Search]. [Inmate
Name], [Inmate Cell Search].CH, [Inmate Cell
Search].Cell, [Inmate Cell Search].Bed, [Inmate Cell
Search].Reason, [Inmate Cell Search].[U/A], [Inmate
Cell Search].Report, [Inmate Cell Search].[Staff # 1],
[Inmate Cell Search].[Staff # 2], [Inmate Cell Search].
[Start Time], [Inmate

Subform 2: Inmate Pat Search Subform
record source: SELECT [Inmate Pat Search].Date,
[Inmate Pat Search].[Inmate Number], [Inmate Pat
Search].Time, [Inmate Pat Search].Staff, [Inmate Pat
Search].Location FROM [Inmate Pat Search];

There's not a code on the 1st subform's Oncurrent Event.
I was thinking I needed something in the event, but
didn't know what to use.

Also, I did the subforms as a tab control. I don't
know if that makes a difference.
.
Click to expand...
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Dilemma 2
Hide Tabs 5
Forms design 1
Not sure if this can be done in access 1
Write to table programmatically 6
Subforms and Linking Help 1
Type mismatch error.. again! 10
Getting the true URL from an .asp site 2

Top