Entered data carried over to subsequent records

G

Gwen

I have 7 unbound textboxes
Users enter info in 7 unbound textboxes using
percentages. The sum of the 7 textboxes automatically
goes into an bound textbox.
My afterdate update event in each of the textbox is: me!
sum = me!txtbox1 + me!txtbox2 + so on.

The problem I having is that when the users enters the
info it carries to the next record.
Also I when I reopen the form the bound textbox data is
missing.
I have tried using the form's on current event form, but
it does not change the text boxes to the default

Private Sub Form_Current()
Forms![Form 1]!sbf1.Form!txtAdmin = Forms![Form 1]!
sbf1.Form!txtAdmin.DefaultValue

Please assist!

Thanks
Gwen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate textbox from combobox selection 2
Populate Textbox from a combobox 3
err 2585 - this action can't be carried out while processing a form or report event 1
use multiple textboxes to filter a listbox 4
Requery two fields? I only asked for one 2
Text box visible on a continuous form 4
ComboBox to update TextBoxes on Form 11
Creating unique calculation form pop-up 4

Top