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
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