Data Entry Property

[mp3455]

I'm working with a table of transactions, and for each customer's record, I have two subforms: one which displays all the customer's transactions ("entry"), and one which allows for data entry of new transactions ("display"). I've been specifically asked to break these functions apart into two distinct subforms.

The "entry" subform has the Data Entry property set to "Yes" and requeries the "display" subform to show the new entry in the AfterUpdate event. The "display" subform has the Data Entry property set to "No."

Ideally, when the user completes a new entry into the "entry" subform, the new transaction will appear in the "display" subform, and the "entry" subform will reset to allow further entries. And this happens, but only for the record of the first customer in the database. For all other records, the "display" subform is successfully requeried, but the "entry" subform will not reset (or go to a new record). This means I cannot make another entry to that customer's page without saving, closing, and reopening the database.

I could probably tell users to click the "New Record" button on the Record Navigator bar of the subform, but I'd rather do without it.

Any idea why I might be seeing the desired results, but only once?

 

[RuralGuy]

What do you have on your "DataEntry" subform that the user uses to signify they have completed the entry?

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[TheAceMan1]

How are ya mp3455 . . .

In parallel with [blue]RuralGuy[/blue], the question is how your saving a record in the [blue]Data Entry[/blue] form? . . . I suggest the following:
[ol][li]Add a [blue]Command Button[/blue] to the Data Entry form for saving. The code in the button would be:

[blue]   DoCmd.RunCommand acCmdSaveRecord
   Me.parent![[purple][B][I]DisplaySubformName[/I][/B][/purple]].Form.Requery
   DoCmd.RunCommand acCmdRecordsGoToNew[/blue]

[/li]
[li]For the above to work properly the forms [blue]Cycle[/blue] property needs to be set to [blue]Current Record[/blue]. This disallows premature saves until the button is hit![/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886