Hi Mark,
I already thought of that as well, did a check again. The record
source is the table itself and there are no filters applied in the
form, the filter entry in the form properties window is empty.
There are however, a few listboxes that look up some values in the
table used as record source. IMHO that shouldn't be a problem because
the cycling of records works during the 'session' (opening the form
entering records, scrolling through the entered records, clsoing the
form). What do you think?
Jonathan
"Mark" <ma*********@ntlworld.com> wrote in message news:<Oc**********@newsfe3-win.ntli.net>...
here's just a few ideas..... is there a filter set on the form? is the
source of the form the table it's self or is it on a query of the table. I
would imagine that the latter of the 2 is the case where the query it is
based on specifies that a field is = "" or is null.
Mark
"-:= Cactus" <jo**************@gmx.net> wrote in message
news:23*************************@posting.google.co m... Hi!
I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1, despite more records
already being entered in the table.
If I add a new record it is saved in the table and the total count of
records is indeed increased by one. I can than scroll to the two
records but it is not possible to scroll through the records that were
put in the table before I last time opened the form. Adding new
records works, and also scrolling through them works until I close the
form and reopen it. Than the stories continues from the start again...
no records until I start adding, but the previously entered records
aren't taken into account.
Can someone help me solve the problem or give a hint where to look
because I'm stuck!
Thanks!
Jonathan