AutoNumber PK affecting combobox?

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

Hi,

I have a 2 field table, where the primary key is an AutoNumber field and the
second field simply a text field.

When I use the second field in a combo-box I'm unable to get the combo to
appear blank when the form is first opened - it always displays the first
record in the underlying record source (meaning the wrong value could be
selected if the user neglected to change the drop-down selection).

However, if the PK isn't an AutoNumber field then the combo does appear
empty when the form is first opened and the user makes their first drop-down
selection.

Am I understanding this behaviour correctly? and if so, is there any way to
make the combo 'appear' empty when the form is first opened for record
sources where the PK is AutoNumber?

Any help/clarification greatly appreciated.......Regards, Jason
 

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

Dynamic Naming of Form Button 3
AutoNumbered PK, "Invalid Argument" At 20,847,689? 4
Copy value of primary key to field in continuous form 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Cascading ComboBox on SubForm 6
Format problem using combo box 1
Form automatically adds new record 2
Data Entry Form and Auto Number ID 2

Top