problem with data entry, pls. help

S

sheela

Good morning everyone!

I am having a problem in updating the value in a forms
text box and combo box. This may be simple to many of you.
I have a form to enter multiple records into a table.
I am using the following code to that.


With Me.RecordsetClone
For k = Me.txtStartPosition.Value To
Me.txtEndPosition.Value
.AddNew
!Position = k
!Storedby = Me!txtStoredby
!StoredDate = Me!txtStoredDate
!StorageTemp = Me!txtStorageTemp
!FreezerName = Me!cmbFreezerName
....
...
.Update
Next k
End With

We were using this form to enter records, it worked fine.
But the problem is every time the user has to open and
type all the values into the form.
Once he clicks on save, the values will be saved and the
form will be closed. Many times he has to enter multiple
records and many field values will be same as the previous
entry. I want the same form keep open, holding the saved
values and ask the user to type the new values for the
next entry, then click on the save button.
But the form is not updating the newly typed values; the
form is automatically updating to previously saved values,
even after we type the new values into the text box. How
do I update the typed values in a text box and combobox,
once they type the values? I am using the following code,
but doesn't work.

Me!txtStartPosition.SetFocus
Me!txtStartPosition.Value = Me!txtStartPosition.Text

Me!txtEndPosition.SetFocus
Me!txtEndPosition.Value = Me!txtEndPosition.Text

I appreciate any help.
Thank you,
sheela
 

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

Top