Filter in my form

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

Guest

I am having problems adding records to my form. After I add a record, it
doesnt show. There was a filter in the form, somehow. I don't even know how
a filter got there in the first place either. I removed the filter in the
Properties Box but it still acts like it is filtering. However, if I close
the form and reopen it, the record is there. What do I do to fix this?
 
Flipper said:
I am having problems adding records to my form. After I add a record, it
doesnt show. There was a filter in the form, somehow. I don't even know
how
a filter got there in the first place either. I removed the filter in the
Properties Box but it still acts like it is filtering. However, if I
close
the form and reopen it, the record is there. What do I do to fix this?
Click to expand...

What code is behind the form?

Keith.
www.keithwilby.com
 
I checked that and it is set to "no". Someone told me to put in "Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping either.
Plus it just tells me that it can't find the macro "me"
 
Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the ones
entered earlier? Only particular ones?
 
Someone has had me put that in On Current and then they also had me put
somethint in on open fields. Neither has helped me. My form still acts like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it says
"applications", which I assume links to the applications table, like it is
suppose to.

The records that are missing are any that I enter. They will appear if I
close the form and reopen, or if i click on remove filter/sort. But I don't
want to have to do that every time.
 
Okay, so the records are being saved in the table, and they do show up if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to [Event
Procedure]. With event procedure, you can then open a code window and insert
the stuff people told you there. But, you don't need to do any of that! The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.
 
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the very
first record I ever entered). Then it justs says 1 of 1. No, it does not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

Allen Browne said:
Okay, so the records are being saved in the table, and they do show up if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to [Event
Procedure]. With event procedure, you can then open a code window and insert
the stuff people told you there. But, you don't need to do any of that! The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
Someone has had me put that in On Current and then they also had me put
somethint in on open fields. Neither has helped me. My form still acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it says
"applications", which I assume links to the applications table, like it is
suppose to.

The records that are missing are any that I enter. They will appear if I
close the form and reopen, or if i click on remove filter/sort. But I
don't
want to have to do that every time.
Click to expand...
Click to expand...
 
I would post my db if I knew I could on here. Can i?

Flipper said:
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the very
first record I ever entered). Then it justs says 1 of 1. No, it does not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

Allen Browne said:
Okay, so the records are being saved in the table, and they do show up if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to [Event
Procedure]. With event procedure, you can then open a code window and insert
the stuff people told you there. But, you don't need to do any of that! The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
Someone has had me put that in On Current and then they also had me put
somethint in on open fields. Neither has helped me. My form still acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it says
"applications", which I assume links to the applications table, like it is
suppose to.

The records that are missing are any that I enter. They will appear if I
close the form and reopen, or if i click on remove filter/sort. But I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a record,
it
doesnt show. There was a filter in the form, somehow. I don't even
know
how
a filter got there in the first place either. I removed the filter in
the
Properties Box but it still acts like it is filtering. However, if I
close
the form and reopen it, the record is there. What do I do to fix this?
Click to expand...
Click to expand...
Click to expand...
 
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
I would post my db if I knew I could on here. Can i?

Flipper said:
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

Allen Browne said:
Okay, so the records are being saved in the table, and they do show up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to
[Event
Procedure]. With event procedure, you can then open a code window and
insert
the stuff people told you there. But, you don't need to do any of that!
The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had me
put
somethint in on open fields. Neither has helped me. My form still
acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it
says
"applications", which I assume links to the applications table, like
it is
suppose to.

The records that are missing are any that I enter. They will appear
if I
close the form and reopen, or if i click on remove filter/sort. But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering. However,
if I
close
the form and reopen it, the record is there. What do I do to fix
this?
Click to expand...
Click to expand...
Click to expand...
 
I didn't want you to work on my db, I wanted you to look at it so you knew
what i was talking about.

Allen Browne said:
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
I would post my db if I knew I could on here. Can i?

Flipper said:
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do show up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to
[Event
Procedure]. With event procedure, you can then open a code window and
insert
the stuff people told you there. But, you don't need to do any of that!
The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had me
put
somethint in on open fields. Neither has helped me. My form still
acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it
says
"applications", which I assume links to the applications table, like
it is
suppose to.

The records that are missing are any that I enter. They will appear
if I
close the form and reopen, or if i click on remove filter/sort. But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering. However,
if I
close
the form and reopen it, the record is there. What do I do to fix
this?
Click to expand...
Click to expand...
Click to expand...
 
When I rt. click on the subform, and go to properties, I do not have parent
and child properties on there...

Allen Browne said:
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
I would post my db if I knew I could on here. Can i?

Flipper said:
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do show up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to
[Event
Procedure]. With event procedure, you can then open a code window and
insert
the stuff people told you there. But, you don't need to do any of that!
The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had me
put
somethint in on open fields. Neither has helped me. My form still
acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it
says
"applications", which I assume links to the applications table, like
it is
suppose to.

The records that are missing are any that I enter. They will appear
if I
close the form and reopen, or if i click on remove filter/sort. But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering. However,
if I
close
the form and reopen it, the record is there. What do I do to fix
this?
Click to expand...
Click to expand...
Click to expand...
 
The record source says "applications"

Allen Browne said:
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
I would post my db if I knew I could on here. Can i?

Flipper said:
When I am entering new records it will show 1 of (how ever many I enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but it
still acts like it is filtering. I also wonder if all this is happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do show up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*] of 5

After entering a record, can you use the left 2 buttons to move back to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or to
[Event
Procedure]. With event procedure, you can then open a code window and
insert
the stuff people told you there. But, you don't need to do any of that!
The
default behavior in Access is to show all the records. When you finish
entering a record, it automatically takes you to a new one. It does not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had me
put
somethint in on open fields. Neither has helped me. My form still
acts
like
it has a filter. I did delete the filter that was next to the filter
property. But it still filters. In the record source property, it
says
"applications", which I assume links to the applications table, like
it is
suppose to.

The records that are missing are any that I enter. They will appear
if I
close the form and reopen, or if i click on remove filter/sort. But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name? a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering. However,
if I
close
the form and reopen it, the record is there. What do I do to fix
this?
Click to expand...
Click to expand...
Click to expand...
 
Is "applications" the name of a table or a query?

If you have a subform, you do have the LinkMasterFields and LinkChildFields
properties once you select the correct object in design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
The record source says "applications"

Allen Browne said:
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click
the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

Flipper said:
I would post my db if I knew I could on here. Can i?

:

When I am entering new records it will show 1 of (how ever many I
enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but
it
still acts like it is filtering. I also wonder if all this is
happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the
nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do show
up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*]
of 5

After entering a record, can you use the left 2 buttons to move back
to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record
present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or
to
[Event
Procedure]. With event procedure, you can then open a code window
and
insert
the stuff people told you there. But, you don't need to do any of
that!
The
default behavior in Access is to show all the records. When you
finish
entering a record, it automatically takes you to a new one. It does
not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had
me
put
somethint in on open fields. Neither has helped me. My form
still
acts
like
it has a filter. I did delete the filter that was next to the
filter
property. But it still filters. In the record source property,
it
says
"applications", which I assume links to the applications table,
like
it is
suppose to.

The records that are missing are any that I enter. They will
appear
if I
close the form and reopen, or if i click on remove filter/sort.
But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name?
a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering.
However,
if I
close
the form and reopen it, the record is there. What do I do to
fix
this?
Click to expand...
Click to expand...
Click to expand...
 
Applications is the name of the table. What subform control are you speaking
of? I just have a tab control that my subform is on. Where do I right click
Is "applications" the name of a table or a query?

If you have a subform, you do have the LinkMasterFields and LinkChildFields
properties once you select the correct object in design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
The record source says "applications"

Allen Browne said:
What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View (View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view, right-click
the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best we
can do is give suggestions to help you solve your issue.

I would post my db if I knew I could on here. Can i?

:

When I am entering new records it will show 1 of (how ever many I
enter).
But when I close the form and go back in, it only shows 1 record (the
very
first record I ever entered). Then it justs says 1 of 1. No, it does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it, but
it
still acts like it is filtering. I also wonder if all this is
happening
because I originaly removed the navigation bars from the subforms and
left
just the form nav. bar. Then I took off the form nav bar and put the
nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do show
up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*]
of 5

After entering a record, can you use the left 2 buttons to move back
to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record
present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro, or
to
[Event
Procedure]. With event procedure, you can then open a code window
and
insert
the stuff people told you there. But, you don't need to do any of
that!
The
default behavior in Access is to show all the records. When you
finish
entering a record, it automatically takes you to a new one. It does
not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also had
me
put
somethint in on open fields. Neither has helped me. My form
still
acts
like
it has a filter. I did delete the filter that was next to the
filter
property. But it still filters. In the record source property,
it
says
"applications", which I assume links to the applications table,
like
it is
suppose to.

The records that are missing are any that I enter. They will
appear
if I
close the form and reopen, or if i click on remove filter/sort.
But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table name?
a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add a
record,
it
doesnt show. There was a filter in the form, somehow. I don't
even
know
how
a filter got there in the first place either. I removed the
filter in
the
Properties Box but it still acts like it is filtering.
However,
if I
close
the form and reopen it, the record is there. What do I do to
fix
this?
Click to expand...
Click to expand...
Click to expand...
 
Open the form in design view.
Open the Properties box (View menu.)
Show the correct page of the tab control.
Click on the edge of the subform.
Check that the Title bar of the Properties box includes:
subform/subreport
Check on the Data tab of the Properties box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Flipper said:
Applications is the name of the table. What subform control are you
speaking
of? I just have a tab control that my subform is on. Where do I right
click
Is "applications" the name of a table or a query?

If you have a subform, you do have the LinkMasterFields and
LinkChildFields
properties once you select the correct object in design view.

Flipper said:
The record source says "applications"

:

What is in the RecordSource property of this form?
If it is a SQL statement, post the statement.
If it is a query, open the query in design view, switch to SQL View
(View
menu), and post the SQL statement.

Is this a subform? If so, open the main form in design view,
right-click
the
edge of the subform control, and choose Properties. What is in these
properties:
Link Master Fields
Link Child Fields

We cannot open your database and work on it for you for free. The best
we
can do is give suggestions to help you solve your issue.

I would post my db if I knew I could on here. Can i?

:

When I am entering new records it will show 1 of (how ever many I
enter).
But when I close the form and go back in, it only shows 1 record
(the
very
first record I ever entered). Then it justs says 1 of 1. No, it
does
not
say filtered on it anywhere. It used to have a filter in the table
properties, though I do not know how it got there. I removed it,
but
it
still acts like it is filtering. I also wonder if all this is
happening
because I originaly removed the navigation bars from the subforms
and
left
just the form nav. bar. Then I took off the form nav bar and put
the
nav
bars back on the subforms.

:

Okay, so the records are being saved in the table, and they do
show
up
if
you reload the form. That's good news.

At the bottom of the form, do you have the navigation buttons?
They look like this:
[|<] [ < ] [ 1] [ > ] [>|] [>*]
of 5

After entering a record, can you use the left 2 buttons to move
back
to
record you entered before?
Does the number in the middle always say 1?
Does the number at the end indicate there's more than 1 record
present?
Does the word "filtered" show beside the last number?

The property settings can be set to either the name of a macro,
or
to
[Event
Procedure]. With event procedure, you can then open a code window
and
insert
the stuff people told you there. But, you don't need to do any of
that!
The
default behavior in Access is to show all the records. When you
finish
entering a record, it automatically takes you to a new one. It
does
not
automatically unload all the existing ones.

Someone has had me put that in On Current and then they also
had
me
put
somethint in on open fields. Neither has helped me. My form
still
acts
like
it has a filter. I did delete the filter that was next to the
filter
property. But it still filters. In the record source
property,
it
says
"applications", which I assume links to the applications table,
like
it is
suppose to.

The records that are missing are any that I enter. They will
appear
if I
close the form and reopen, or if i click on remove filter/sort.
But
I
don't
want to have to do that every time.

:

Are you saying you set the form's On Current property to:
Me.FilterOn = False
That is not correct, and it is not an idea worth pursuing.

If you wish, you can open the form in design view, and delete
whatever is
beside the form's Filter property.

What is in the form's RecordSource property? Is it a table
name?
a
query
name? a SQL statement?

Are all records missing? Only the one you just entered? Only
the
ones
entered earlier? Only particular ones?

I checked that and it is set to "no". Someone told me to put
in
"Me.FilterOn
= False
" in the on Current field in properties, but that isn't
helping
either.
Plus it just tells me that it can't find the macro "me"

:

I am having problems adding records to my form. After I add
a
record,
it
doesnt show. There was a filter in the form, somehow. I
don't
even
know
how
a filter got there in the first place either. I removed
the
filter in
the
Properties Box but it still acts like it is filtering.
However,
if I
close
the form and reopen it, the record is there. What do I do
to
fix
this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top