dbTalk Databases Forums  

bound form not displaying records

comp.databases.ms-access comp.databases.ms-access


Discuss bound form not displaying records in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
RCGUA
 
Posts: n/a

Default bound form not displaying records - 07-27-2009 , 02:44 PM






I have a bound form that is set to open to a new record. The user
picks from a combox, types in an amount in a text box, etc, then saves
the record and the record is entered into the table. The previous
records exist in the table, however, when I click on the record
selectors to try to scroll through the records, the records don't
display in the corresponding text boxes, etc., the boxes are all
blank. The record numbers change, but not the actual data from the
table.

Reply With Quote
  #2  
Old   
fredg
 
Posts: n/a

Default Re: bound form not displaying records - 07-27-2009 , 03:37 PM






On Mon, 27 Jul 2009 11:44:20 -0700 (PDT), RCGUA wrote:

Quote:
I have a bound form that is set to open to a new record. The user
picks from a combox, types in an amount in a text box, etc, then saves
the record and the record is entered into the table. The previous
records exist in the table, however, when I click on the record
selectors to try to scroll through the records, the records don't
display in the corresponding text boxes, etc., the boxes are all
blank. The record numbers change, but not the actual data from the
table.
Can't see your database, but I would venture a guess that the form's
DataEntry property is set to Yes.
If you wish to see older records set the DataEntry property to No.
Also set the Allow Edits and Allow Additions properties to Yes.

If you always wish the form to open at a New Record when the form is
first opened, code the Form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply With Quote
  #3  
Old   
RCGUA
 
Posts: n/a

Default Re: bound form not displaying records - 07-27-2009 , 05:38 PM



On Jul 27, 2:37*pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:
Quote:
On Mon, 27 Jul 2009 11:44:20 -0700 (PDT), RCGUA wrote:
I have a bound form that is set to open to a new record. *The user
picks from a combox, types in an amount in a text box, etc, then saves
the record and the record is entered into the table. *The previous
records exist in the table, however, when I click on the record
selectors to try to scroll through the records, the records don't
display in the corresponding text boxes, etc., the boxes are all
blank. *The record numbers change, but not the actual data from the
table.

Can't see your database, but I would venture a guess that the form's
DataEntry property is set to Yes.
If you wish to see older records set the DataEntry property to No.
Also set the Allow Edits and Allow Additions properties to Yes.

If you always wish the form to open at a New Record when the form is
first opened, code the Form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Thank you, it was the DateEntry property.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.