when i select a value in one combobox - all CB values change to sa

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

Guest

I have a form that is set as datasheet view.. why when i select 1 value in
any of the combo boxes (regardless of which record) - all of the records
combo boxes change to this value??.. i only want the one i'm changing to
change. And how can i change the datasheet view to only show me one record
at a time (after the first record selection then want to show new record - to
select another value - I don't want to see a list of empty records). Thanks!
- jenn
 
I have a form that is set as datasheet view.. why when i select 1 value in
any of the combo boxes (regardless of which record) - all of the records
combo boxes change to this value??.. i only want the one i'm changing to
change. And how can i change the datasheet view to only show me one record
at a time (after the first record selection then want to show new record - to
select another value - I don't want to see a list of empty records). Thanks!
- jenn
Click to expand...

It sounds like this particular combo box is unbound. An unbound
Control in a datasheet or continuous form appears on each row - but
it's actually only one control, shown repeatedly. Check the form in
design view and make sure that the combo box has its Control Source as
the table field you want to see.

If you only want to see one record, don't use a Datasheet. A datasheet
is designed to be a multirecord display. Change the Default View
property of your form from Datasheet to Single Form, and you'll only
see one record. If you like the datasheet view (which I really don't,
I prefer Continuous Forms since they're more flexible), you can leave
it Datasheet and set the Data Entry property of the form to True to
see only the "new" record.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top