[AccessD] RowSource Question

Hi Dale
Once you have 'run' the Me.cboSecRoleKey.RowSource = something code, perhaps
a Me.cboSecRoleKey.Requery is needed.
Though when I tested it - I attached the population of the row source to a
button click, and it worked without a requery

Private Sub Command2_Click()
Me.cboSecRoleKey.RowSource = "0;'Administrator MN';1;'Administrator
NY';2;'View Only'"
End Sub

As Stuart mentions - Are we able to see how you are 'calling' the population
of the combo? What code is invoking it?
D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, 7 July 2012 7:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] RowSource Question

What event proc/ function do you currently have the
"Me.cboSecRoleKey.RowSource ="  in? 
How are you invoking it?

-- 
Stuart



On 6 Jul 2012 at 9:33, Dale Kalsow wrote:

> Yes I do
> 
>  
> cpd in.
> ________________________________
>  From: Stuart McLachlan <stuart at lexacorp.com.pg>
> To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com> 
> Sent: Friday, July 6, 2012 11:27 AM
> Subject: Re: [AccessD] RowSource Question
>   
> Have you set RowSourceType to "Value List" and ColumnCount to 2 ?
> 
> On 6 Jul 2012 at 9:10, Dale Kalsow wrote:
> 
> > Good Morning,
> >  
> > I have the following code.  My program is running it without any errors
but the it does not actually update the combo box.  What do I need to do
refresh the combo box?
> >  
> > Thanks!
> >  
> > Dale
> > 
> > Me.cboSecRoleKey.RowSource = "0;'Administrator MN';1;'Administrator
NY';2;'View Only'" 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com/
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com