By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Problem cycling records

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
jo**************@gmx.net (-:= Cactus) wrote:
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.


Jonathan,

Is the form's "Data Entry" property set to 'Yes'? If so set it to 'No' and
try again.

HTH - Keith.
Nov 13 '05 #3

P: n/a
Hi Jonathan,

Check the properties of your form. Under the 'Data' tab, I suspect your
'Data Entry' property is set to 'Yes'. Change it to 'No' and all should
be hunky-dory!

-------
LoopyNZ
-------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a
Hi!

This suggestion worked indeed... but the problem with using a
switchboard is that you can choose to open a form in either add mode
(form with DataEntry set to TRUE) and in edit mode (as a table).

Therefore I had to add the Me.DataEntrye = False line to the Form_Load
sub to keep it opened with dataentry set to false.

Thans very much for your suggestions, they pointed me to the solution!

Jonathan

LoopyNZ <Lo*****@NOguruSPPAM.net.nz> wrote in message news:<41**********************@news.newsgroups.ws> ...
Hi Jonathan,

Check the properties of your form. Under the 'Data' tab, I suspect your
'Data Entry' property is set to 'Yes'. Change it to 'No' and all should
be hunky-dory!

-------
LoopyNZ
-------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.