Rut Roh Filter by Form

[LMB]

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform based on a query but I couldn't add records on the subform even though all of the enter data properties were set to yes. When I took the group by out of the query, I could update my subform. My main form has employee name and the data entry property is set to no. Now when I open my main form, the main fields are blank. If I click on the filter by form tool button and then click on the filter button, my employee names are there again and both the main form and my subform work. Then if I close out and open back up, my employee names are there but my subform is in the add records only unless I click the filter by form tool button and then filter tool button. It just keeps flip flopping. I looked up filter by form but none of it seems to help me figure out how to fix this little problem. I compacted and repaired the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform
based on a query but I couldn't add records on the subform even though all
of the enter data properties were set to yes. When I took the group by out
of the query, I could update my subform. My main form has employee name and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and both
the main form and my subform work. Then if I close out and open back up, my
employee names are there but my subform is in the add records only unless I
click the filter by form tool button and then filter tool button. It just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to
the VB or SQL version <g>

Thanks,
Linda

 

[LMB]

Nope...Nothing in the filter property for either form...main or subform. Now the Main form is working fine but the subform still is wacky....I can only get it to work if I click on filter by form tool button and then the filter button. There is nothing in the events tab of the properties. Here is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate, TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID = TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform
based on a query but I couldn't add records on the subform even though all
of the enter data properties were set to yes. When I took the group by out
of the query, I could update my subform. My main form has employee name and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and both
the main form and my subform work. Then if I close out and open back up, my
employee names are there but my subform is in the add records only unless I
click the filter by form tool button and then filter tool button. It just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to
the VB or SQL version <g>

Thanks,
Linda

 

[LMB]

Hey, I got it working! I had another subform...this was my first attempt that didn't work and it was still in my forms list. I deleted that and now my main form and subform on a tab works. What is the proper way to describe a subform on a tabbed form anyway?

Thanks,
Linda


Nope...Nothing in the filter property for either form...main or subform. Now the Main form is working fine but the subform still is wacky....I can only get it to work if I click on filter by form tool button and then the filter button. There is nothing in the events tab of the properties. Here is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate, TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID = TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform
based on a query but I couldn't add records on the subform even though all
of the enter data properties were set to yes. When I took the group by out
of the query, I could update my subform. My main form has employee name and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and both
the main form and my subform work. Then if I close out and open back up, my
employee names are there but my subform is in the add records only unless I
click the filter by form tool button and then filter tool button. It just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to
the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

What are the fields being used as the LinkChildFields and LinkMasterFields
properties for the subform control that is on the main form?

What is the source of the TBLAreaWorked.WorkAreaID value?

--

Ken Snell
<MS ACCESS MVP>

Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties. Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform
based on a query but I couldn't add records on the subform even though all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back up,
my
employee names are there but my subform is in the add records only unless
I
click the filter by form tool button and then filter tool button. It just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to
the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

I am not understanding what you mean by "describe a subform on a tabber
form"? Please provide a bit more info -- describe it in terms of explaining
it? in terms of referencing it via code?

--

Ken Snell
<MS ACCESS MVP>

Hey, I got it working! I had another subform...this was my first attempt
that didn't work and it was still in my forms list. I deleted that and now
my main form and subform on a tab works. What is the proper way to describe
a subform on a tabbed form anyway?

Thanks,
Linda


Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties. Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form
and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a
subform
based on a query but I couldn't add records on the subform even though
all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back
up, my
employee names are there but my subform is in the add records only
unless I
click the filter by form tool button and then filter tool button. It
just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast
to
the VB or SQL version <g>

Thanks,
Linda

 

[LMB]

Even though I have it working, I want to try to understand and answer your question. I really appreciate your help.
What are the fields being used as the LinkChildFields and LinkMasterFields
properties for the subform control that is on the main form?

**********
There is no LinkChildFields and LinkMasterFields in that subform. When I looked at a subform on another tab which I kind of modeled this one after, I have those fields but not on this subform. I did use the wizard so I am sure the wizard does the right thing but I really don't know for sure what all it does.
************

What is the source of the TBLAreaWorked.WorkAreaID value?

**********
Ummm how do I find that? I have 2 queries joined together so that the work area ID is not what the user see's when they choose from my combo-box on my form for the work area field. The Work area table has a work areaID and then the name of the work area.
***************

--

Ken Snell
<MS ACCESS MVP>

Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties. Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;



Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a subform
based on a query but I couldn't add records on the subform even though all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back up,
my
employee names are there but my subform is in the add records only unless
I
click the filter by form tool button and then filter tool button. It just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast to
the VB or SQL version <g>

Thanks,
Linda

 

[LMB]

It just doesn't sound like it is proper verbiage. I have a main form which shows the employee name then on that form, I used the toolbox and added a tab control. When I have a new type of subform to add, I add a new page. So maybe it's just "a subform on a page of a tab control on a form?

Thanks,
Linda

I am not understanding what you mean by "describe a subform on a tabber
form"? Please provide a bit more info -- describe it in terms of explaining
it? in terms of referencing it via code?

--

Ken Snell
<MS ACCESS MVP>

Hey, I got it working! I had another subform...this was my first attempt
that didn't work and it was still in my forms list. I deleted that and now
my main form and subform on a tab works. What is the proper way to describe
a subform on a tabbed form anyway?

Thanks,
Linda


Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties. Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form
and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a
subform
based on a query but I couldn't add records on the subform even though
all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back
up, my
employee names are there but my subform is in the add records only
unless I
click the filter by form tool button and then filter tool button. It
just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast
to
the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

Oh - it's a subform on a main form where the subform is located on a page of
a tab control. Even though the subform is on that page, it's still a child
of the main form, not a child of the tab control.

--

Ken Snell
<MS ACCESS MVP>

It just doesn't sound like it is proper verbiage. I have a main form which
shows the employee name then on that form, I used the toolbox and added a
tab control. When I have a new type of subform to add, I add a new page.
So maybe it's just "a subform on a page of a tab control on a form?

Thanks,
Linda

I am not understanding what you mean by "describe a subform on a tabber
form"? Please provide a bit more info -- describe it in terms of
explaining
it? in terms of referencing it via code?

--

Ken Snell
<MS ACCESS MVP>

Hey, I got it working! I had another subform...this was my first attempt
that didn't work and it was still in my forms list. I deleted that and
now
my main form and subform on a tab works. What is the proper way to
describe
a subform on a tabbed form anyway?

Thanks,
Linda


Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties.
Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful
to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;

Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data,
and
delete any string that you find in the Filter property. Save the form
and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a
subform
based on a query but I couldn't add records on the subform even though
all
of the enter data properties were set to yes. When I took the group
by
out
of the query, I could update my subform. My main form has employee
name
and
the data entry property is set to no. Now when I open my main form,
the
main fields are blank. If I click on the filter by form tool button
and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back
up, my
employee names are there but my subform is in the add records only
unless I
click the filter by form tool button and then filter tool button. It
just
keeps flip flopping. I looked up filter by form but none of it seems
to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in
contrast
to
the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

If you open the form in design view, and click on the very top edge of the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two properties
listed there. They are used to join the subform's records to the main form,
based on the fields that are listed there (LinkChildFields are the fields or
field in the subform's record source, and LinkMasterFields are the fields or
field in the main form's record source). This allows the subform to "move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.

--

Ken Snell
<MS ACCESS MVP>



Even though I have it working, I want to try to understand and answer your
question. I really appreciate your help.
What are the fields being used as the LinkChildFields and LinkMasterFields
properties for the subform control that is on the main form?

**********
There is no LinkChildFields and LinkMasterFields in that subform. When I
looked at a subform on another tab which I kind of modeled this one after, I
have those fields but not on this subform. I did use the wizard so I am
sure the wizard does the right thing but I really don't know for sure what
all it does.
************

What is the source of the TBLAreaWorked.WorkAreaID value?

**********
Ummm how do I find that? I have 2 queries joined together so that the
work area ID is not what the user see's when they choose from my combo-box
on my form for the work area field. The Work area table has a work areaID
and then the name of the work area.
***************

--

Ken Snell
<MS ACCESS MVP>

Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties.
Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;



Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form
and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a
subform
based on a query but I couldn't add records on the subform even though
all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back
up,
my
employee names are there but my subform is in the add records only
unless
I
click the filter by form tool button and then filter tool button. It
just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast
to
the VB or SQL version <g>

Thanks,
Linda

 

[LMB]

Well, Ok then..........I'm glad I've got that straight now. <g>

Thank-you
Linda
Oh - it's a subform on a main form where the subform is located on a page of
a tab control. Even though the subform is on that page, it's still a child
of the main form, not a child of the tab control.

--

 

[LMB]

OK. You have to click just in the right spot!

So, I have a form called sfrmAreasWorked that was created in the following manner.... I opened up my Main form in design view and added a page to my tab control. Using my toolbox, I added a subform to that page and it moved me along through a wizard. When I was done with the wizard, I named the subform sfrmAreasWorked. When I open up the sfrmAreasWorked in design view, I don't see the child parent thing, I have a record source of qryAreasWorked. So, is the subform actually an object or is it a link or a kind of a tractor beam between the main form and the form I named sfrmAreasWorked?

Thanks,
Linda
If you open the form in design view, and click on the very top edge of the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two properties
listed there. They are used to join the subform's records to the main form,
based on the fields that are listed there (LinkChildFields are the fields or
field in the subform's record source, and LinkMasterFields are the fields or
field in the main form's record source). This allows the subform to "move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.

--

Ken Snell
<MS ACCESS MVP>



Even though I have it working, I want to try to understand and answer your
question. I really appreciate your help.
What are the fields being used as the LinkChildFields and LinkMasterFields
properties for the subform control that is on the main form?

**********
There is no LinkChildFields and LinkMasterFields in that subform. When I
looked at a subform on another tab which I kind of modeled this one after, I
have those fields but not on this subform. I did use the wizard so I am
sure the wizard does the right thing but I really don't know for sure what
all it does.
************

What is the source of the TBLAreaWorked.WorkAreaID value?

**********
Ummm how do I find that? I have 2 queries joined together so that the
work area ID is not what the user see's when they choose from my combo-box
on my form for the work area field. The Work area table has a work areaID
and then the name of the work area.
***************

--

Ken Snell
<MS ACCESS MVP>

Nope...Nothing in the filter property for either form...main or subform.
Now the Main form is working fine but the subform still is wacky....I can
only get it to work if I click on filter by form tool button and then the
filter button. There is nothing in the events tab of the properties.
Here
is the query sql for the query my subform is based on.

Is there anything else I can document or look for that would be helpful to
investigate this problem?

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas RIGHT JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID;



Thanks,
Linda

Sounds as if the form is saving a previous filter string.

Open the form in design view, open Properties window, click on Data, and
delete any string that you find in the Filter property. Save the form
and
then close it.

See if that fixes this problem.

--

Ken Snell
<MS ACCESS MVP>

Hi Guys,

Fixed one problem and caused another...I think. Earlier, I had a
subform
based on a query but I couldn't add records on the subform even though
all
of the enter data properties were set to yes. When I took the group by
out
of the query, I could update my subform. My main form has employee name
and
the data entry property is set to no. Now when I open my main form, the
main fields are blank. If I click on the filter by form tool button and
then click on the filter button, my employee names are there again and
both
the main form and my subform work. Then if I close out and open back
up,
my
employee names are there but my subform is in the add records only
unless
I
click the filter by form tool button and then filter tool button. It
just
keeps flip flopping. I looked up filter by form but none of it seems to
help me figure out how to fix this little problem. I compacted and
repaired
the database but that didn't help the situation.

Access 2000, I need the push this button, click here answer in contrast
to
the VB or SQL version <g>

Thanks,
Linda

 

[Ken Snell [MVP]]

What you're looking at is the form that is serving as the subform. You're
not looking at the subform control. Go back to the main form in design view
and follow the steps that I outlined previously. The subform control is the
control that holds the subform; it's not the form that is serving as the
subform.

Note that it's not necessary for the LinkChildFields and LinkMasterFields
properties to contain any values at all. They should contain values only if
you want the subform's records to always be the related children records of
whatever record is active on the main form at that time (and then only if
you want ACCESS to automatically do the tracking -- you can do this via code
on your own if you wish).

--

Ken Snell
<MS ACCESS MVP>

OK. You have to click just in the right spot!

So, I have a form called sfrmAreasWorked that was created in the following
manner.... I opened up my Main form in design view and added a page to my
tab control. Using my toolbox, I added a subform to that page and it moved
me along through a wizard. When I was done with the wizard, I named the
subform sfrmAreasWorked. When I open up the sfrmAreasWorked in design view,
I don't see the child parent thing, I have a record source of
qryAreasWorked. So, is the subform actually an object or is it a link or a
kind of a tractor beam between the main form and the form I named
sfrmAreasWorked?

Thanks,
Linda
If you open the form in design view, and click on the very top edge of the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two
properties
listed there. They are used to join the subform's records to the main
form,
based on the fields that are listed there (LinkChildFields are the fields
or
field in the subform's record source, and LinkMasterFields are the fields
or
field in the main form's record source). This allows the subform to "move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.

 

[LMB]

Does having the child and master fields linked slow down the loading of the form? Lately when loading the form, we see the word "calculating..." in the status bar for a few seconds.

I am not nearly ready for making any code but....where do you make the code if you want to do that?

Thanks,
Linda
What you're looking at is the form that is serving as the subform. You're
not looking at the subform control. Go back to the main form in design view
and follow the steps that I outlined previously. The subform control is the
control that holds the subform; it's not the form that is serving as the
subform.

Note that it's not necessary for the LinkChildFields and LinkMasterFields
properties to contain any values at all. They should contain values only if
you want the subform's records to always be the related children records of
whatever record is active on the main form at that time (and then only if
you want ACCESS to automatically do the tracking -- you can do this via code
on your own if you wish).

--

Ken Snell
<MS ACCESS MVP>

OK. You have to click just in the right spot!

So, I have a form called sfrmAreasWorked that was created in the following
manner.... I opened up my Main form in design view and added a page to my
tab control. Using my toolbox, I added a subform to that page and it moved
me along through a wizard. When I was done with the wizard, I named the
subform sfrmAreasWorked. When I open up the sfrmAreasWorked in design view,
I don't see the child parent thing, I have a record source of
qryAreasWorked. So, is the subform actually an object or is it a link or a
kind of a tractor beam between the main form and the form I named
sfrmAreasWorked?

Thanks,
Linda
If you open the form in design view, and click on the very top edge of the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two
properties
listed there. They are used to join the subform's records to the main
form,
based on the fields that are listed there (LinkChildFields are the fields
or
field in the subform's record source, and LinkMasterFields are the fields
or
field in the main form's record source). This allows the subform to "move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.

 

[Ken Snell [MVP]]

I've not noted those linking fields slowing a form's loading. What makes a
form load slowly usually is the number of records that the query is
returning for the form's recordset, or with the time it takes for the query
to run.

Slow-loading forms can be partially avoided by
- filtering the form's recordset as part of the OpenForm action that
opens the form (use the WHERE argument of that method);
- having the form load with a blank record source string, and then use
code to set the record source string once the filtering desires have been
identified on the form (this is good only if you're using filtering combos,
etc. on the form to filter the data to be displayed).

--

Ken Snell
<MS ACCESS MVP>

Does having the child and master fields linked slow down the loading of the
form? Lately when loading the form, we see the word "calculating..." in the
status bar for a few seconds.

I am not nearly ready for making any code but....where do you make the code
if you want to do that?

Thanks,
Linda
What you're looking at is the form that is serving as the subform. You're
not looking at the subform control. Go back to the main form in design
view
and follow the steps that I outlined previously. The subform control is
the
control that holds the subform; it's not the form that is serving as the
subform.

Note that it's not necessary for the LinkChildFields and LinkMasterFields
properties to contain any values at all. They should contain values only
if
you want the subform's records to always be the related children records
of
whatever record is active on the main form at that time (and then only if
you want ACCESS to automatically do the tracking -- you can do this via
code
on your own if you wish).

--

Ken Snell
<MS ACCESS MVP>

OK. You have to click just in the right spot!

So, I have a form called sfrmAreasWorked that was created in the following
manner.... I opened up my Main form in design view and added a page to my
tab control. Using my toolbox, I added a subform to that page and it
moved
me along through a wizard. When I was done with the wizard, I named the
subform sfrmAreasWorked. When I open up the sfrmAreasWorked in design
view,
I don't see the child parent thing, I have a record source of
qryAreasWorked. So, is the subform actually an object or is it a link or
a
kind of a tractor beam between the main form and the form I named
sfrmAreasWorked?

Thanks,
Linda
If you open the form in design view, and click on the very top edge of
the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two
properties
listed there. They are used to join the subform's records to the main
form,
based on the fields that are listed there (LinkChildFields are the
fields
or
field in the subform's record source, and LinkMasterFields are the
fields
or
field in the main form's record source). This allows the subform to
"move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.

 

[LMB]

Thanks,

I'll put this in my forms folder to look at when I am ready to make some code on forms. I am totally re-building this employee database but needed to get this "worked areas" thing going right away in the old one.

I am almost done with my crosstab query but will probably need help so...I'll be baaaack. Thanks for all your help and have a great day!

Linda


I've not noted those linking fields slowing a form's loading. What makes a
form load slowly usually is the number of records that the query is
returning for the form's recordset, or with the time it takes for the query
to run.

Slow-loading forms can be partially avoided by
- filtering the form's recordset as part of the OpenForm action that
opens the form (use the WHERE argument of that method);
- having the form load with a blank record source string, and then use
code to set the record source string once the filtering desires have been
identified on the form (this is good only if you're using filtering combos,
etc. on the form to filter the data to be displayed).

--

Ken Snell
<MS ACCESS MVP>

Does having the child and master fields linked slow down the loading of the
form? Lately when loading the form, we see the word "calculating..." in the
status bar for a few seconds.

I am not nearly ready for making any code but....where do you make the code
if you want to do that?

Thanks,
Linda
What you're looking at is the form that is serving as the subform. You're
not looking at the subform control. Go back to the main form in design
view
and follow the steps that I outlined previously. The subform control is
the
control that holds the subform; it's not the form that is serving as the
subform.

Note that it's not necessary for the LinkChildFields and LinkMasterFields
properties to contain any values at all. They should contain values only
if
you want the subform's records to always be the related children records
of
whatever record is active on the main form at that time (and then only if
you want ACCESS to automatically do the tracking -- you can do this via
code
on your own if you wish).

--

Ken Snell
<MS ACCESS MVP>

OK. You have to click just in the right spot!

So, I have a form called sfrmAreasWorked that was created in the following
manner.... I opened up my Main form in design view and added a page to my
tab control. Using my toolbox, I added a subform to that page and it
moved
me along through a wizard. When I was done with the wizard, I named the
subform sfrmAreasWorked. When I open up the sfrmAreasWorked in design
view,
I don't see the child parent thing, I have a record source of
qryAreasWorked. So, is the subform actually an object or is it a link or
a
kind of a tractor beam between the main form and the form I named
sfrmAreasWorked?

Thanks,
Linda
If you open the form in design view, and click on the very top edge of
the
subform control (not inside the subform control), and then open the
Properties window and click on the Data tab, you'll see these two
properties
listed there. They are used to join the subform's records to the main
form,
based on the fields that are listed there (LinkChildFields are the
fields
or
field in the subform's record source, and LinkMasterFields are the
fields
or
field in the main form's record source). This allows the subform to
"move"
with the main form as you change records on the main form; the related
records in the subform change to match the one in the main form.