Re: Filter in my form
- From: Flipper <Flipper@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Mar 2006 07:35:02 -0800
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" wrote:
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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Flipper" <Flipper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F7AEADD4-15D6-44B8-B6E5-661AEC46F422@xxxxxxxxxxxxxxxx
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.
"Allen Browne" wrote:
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?
"Flipper" <Flipper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:843A85D0-AB85-471A-9210-588A5D688583@xxxxxxxxxxxxxxxx
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"
"Flipper" wrote:
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?
- Follow-Ups:
- Re: Filter in my form
- From: Flipper
- Re: Filter in my form
- References:
- Re: Filter in my form
- From: Allen Browne
- Re: Filter in my form
- From: Allen Browne
- Re: Filter in my form
- Prev by Date: RE: Alarm problem
- Next by Date: Re: jittery form
- Previous by thread: Re: Filter in my form
- Next by thread: Re: Filter in my form
- Index(es):
Relevant Pages
|
