DataRelations

  • Thread starter Thread starter Merlin
  • Start date Start date
M

Merlin

Hey All,

I have a form that connects to a Access database, and I have a combo box on
this form (this combo box has a list of Access Levels, a user would be
able to choose one Access Level out of the combo box).

The combo box is serving double duty, as they usually do, it is giving me a
list of all of the Access Levels in a drop down, and it is also returning
the Access Level of the record that I am retrieving from my Access Database.

Everything works perfectly, but. . .

When I navigate through my records, the combo box (Access Level) does not
change with what the Access Level should be for that particular record, it's
almost like it sticks on the same Access Level. The AccessLevelID
(different text box) changes with every record but the combo box doesn't.

I did some troubleshooting. . .

If I put a text box in place of the combo box it works correctly, but this
does not solve the problem of the user being able to select a Access Level,
hence the need for a combo box.


I`ver tryed to explain this before but unforutnatle i don`t think im
explaining properly, i have a example project that I could e-mail if anybody
could offer me some help?

Any links as I don`t mind reading

Please help.

Thanks.
Merlin
 
Merlin -

Check out the ComboBox.SelectedIndex property:

ComboBox.SelectedItem Property (.NET Framework)
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemwindowsformsco
mboboxclassselecteditemtopic.asp




This topic implements a databound combobox that may help you:

Navigating Multiple Related Tables in an ADO.NET Dataset
http://msdn.microsoft.com/library/en-us/dv_vstechart/html/vbtchNavigatingMul
tipleRelatedTablesInADONETDataset.asp



Steve Stein
VB Team

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
 
Back
Top