Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 30th, 2005, 08:33 AM
Authorized User
 
Join Date: Nov 2005
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Get The Values In The DropDown

I have UserID(ie who has logged in) on the Main Form.

As I Open Form I want to Populate DropDown With ContactID Where UserID is Equal To UserID on the Main Form.

UserID and ContactID are in the Same table.

 I do not want to see All the ContactID but Only Those ContactID Where UserID is Equal to UserID on the Main Form.

OR

How I can Fill Data in The Comobox through code.
I Tried Combox.Value= and Combox.Text=
But it Does'nt Work

Can SomeOne Help Me.

Best Regards,
Vivek.
__________________
Best Regards,
Vivek.
 
Old November 30th, 2005, 04:17 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Look up help for the AddItem method for comboboxes in Access. Also look up help in defining its rowsource.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
checkbox values to dropdown december Classic ASP Professional 1 July 3rd, 2006 08:34 PM
Get The Values In The DropDown vivek_inos Access 2 November 30th, 2005 09:45 AM
Dropdown values dotnewnewbie ASP.NET 1.0 and 1.1 Professional 5 October 28th, 2003 12:31 PM
update dropdown values mateenmohd SQL Server 2000 0 October 9th, 2003 03:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.