![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |