Default Values Do Not Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working in Access 2002 and have a form that has a list box. I want the
field to be empty unless the user chooses something from the list box. I
have set the default values in the table and on the form to be an empty
string ="". I've tried putting in the equals sign and leaving it out.
Nothing seems to work. The new record always comes up with the value from
the previous record.
 
Sounds like you must have some code that is copying the previous record
(since this is not a built in function in Access).

I'd suggest looking at any codes or macros associated with the form.

Rick B
 
You must log in or register to reply here.

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

Default Value on Continuous Form 2
Default Values in Unbounded form 5
Default combo box based on previous record 1
ListBox default value 6
Access Datasheet Default Value 1
Combo Box with Updateable Value List 2
default values in combo box with multiple colimns 1
autofill a field on a form with default value 2

Back
Top