PC Review


Reply
Thread Tools Rate Thread

DataRelations

 
 
Merlin
Guest
Posts: n/a
 
      2nd Mar 2004
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




 
Reply With Quote
 
 
 
 
Steven Stein [MSFT]
Guest
Posts: n/a
 
      8th Mar 2004
Merlin -

Check out the ComboBox.SelectedIndex property:

ComboBox.SelectedItem Property (.NET Framework)
http://msdn.microsoft.com/library/en...windowsformsco
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...hNavigatingMul
tipleRelatedTablesInADONETDataset.asp



Steve Stein
VB Team

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

--------------------
>NNTP-Posting-Date: Tue, 02 Mar 2004 04:10:31 -0600
>From: "Merlin" <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.languages.vb
>Subject: DataRelations
>Date: Tue, 2 Mar 2004 10:13:50 -0000
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <LPGdnXDnz-(E-Mail Removed)>
>Lines: 38
>NNTP-Posting-Host: 213.249.140.82
>X-Trace:

sv3-TMjns3wUxJD+5M1qEF9N0B7lP61Cn9SiArHXrGNa3VIdcJPw6Un060GjbSdfDF2F8+Zy3L+j
ShzTDi1!EcxMYMTX80AaMPXu79GGYP3Oyj7SvKUHjHf4vc+/yASG+Mto5rRD2POvhU2Gi7fOkh04
6swSMA82
>X-Complaints-To: (E-Mail Removed)
>X-DMCA-Complaints-To: (E-Mail Removed)
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your

complaint properly
>X-Postfilter: 1.1
>Path:

cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!tiscali!newsfeed1.ip.tiscali.net!216.196.98.140.MISMATCH!border1.nntp.a
sh.giganews.com!border2.nntp.sjc.giganews.com!border1.nntp.sjc.giganews.com!
nntp.giganews.com!local1.nntp.sjc.giganews.com!nntp.karoo.co.uk!news.karoo.c
o.uk.POSTED!not-for-mail
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:185892
>X-Tomcat-NG: microsoft.public.dotnet.languages.vb
>
>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
>
>
>
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataRelations =?Utf-8?B?RXJpY2E=?= Microsoft Dot NET 1 15th Mar 2007 09:33 PM
DataRelations Aziz Microsoft ADO .NET 0 19th Apr 2006 05:22 PM
DataRelations? Mervin Williams Microsoft ADO .NET 1 11th Mar 2004 03:32 AM
DataRelations Merlin Microsoft ADO .NET 1 7th Mar 2004 01:12 PM
Datarelations pleasehelp Microsoft C# .NET 1 22nd Jul 2003 03:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:53 AM.