Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
Visual Basic Forum for Visual Basic Programmers VB Forum Index » Visual Basic for Applications

Post new topic   Reply to topic
Retrieving the primary key of a record from a combo based on
View previous topic :: View next topic  
Author Message
SKP
Newbie


Joined: 23 Dec 2003
Posts: 7

PostPosted: Jan 8th, 2004 03:31 PM    Post subject: Retrieving the primary key of a record from a combo based on Reply with quote

It's me again! Okay, here's my latest question. I'm trying to set one combo box to contain filtered projects by name based on the selection of a letter in another combo box.

I've gotten this part to work but what I want to do is take the corresponding primary key to the project name (I have a project number set as the primary) and find the record based on that number.

Is there any way I can get the primary key from the selection of the combo box by name???

Thanks in advance!
Back to top
View user's profile Send private message
SKP
Newbie


Joined: 23 Dec 2003
Posts: 7

PostPosted: Jan 9th, 2004 08:00 AM    Post subject: Reply with quote

I figured out my problem, and it ended up being annoyingly easy. I changed the position of the project number in my query to the first position instead of the second so when my combo boxes filter by letter, it's still using the criteria from project name but grabbing the actual number!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Visual Basic Forum for Visual Basic Programmers VB Forum Index » Visual Basic for Applications All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic