Value list

H

Hong

Hello,

In the table, the filed is from a value list: for example is "A" & "B",
Now I am going to delete "B", and add "C".
Is that going to affect the old records who already has the data "B"?

Is it the right way to update any field with the value list?

Thank you!
 
J

John W. Vinson

Hello,

In the table, the filed is from a value list: for example is "A" & "B",
Now I am going to delete "B", and add "C".
Is that going to affect the old records who already has the data "B"?
Click to expand...

No, but you won't be able to see anything in this field for records where the
table contains B.
Is it the right way to update any field with the value list?
Click to expand...

No. If you want to change the value stored in the table, either navigate to
the record and change it, or run an Update query.

A combo box *does not store data*. It's simply a tool to display and edit data
in your table. If you're using a Lookup Field in your table, you may want to
reconsider; read the critique at

http://www.mvps.org/access/lookupfields.htm

John W. Vinson [MVP]
 
J

John W. Vinson

Thank you!
What should I do if i open a form, I want to be on the new record.
Click to expand...

Two choices:

- Set the Form's Data Entry property to True. The disadvantage here is that
you will ONLY be able to enter new records, and not browse back to old ones.

- Put a line of code in the form's Load event. View the form's Properties;
click the ... icon by the Load event on the Events tab; choose Code Builder;
and edit it to

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub

John W. Vinson [MVP]
 
Top