[AccessD] DataGrid Buttons

Paul,
I assume you are talking about the msdatgrd.ocx control. I have a vba
example somewhere but I can't find it right now. 
What you need to do is create a hidden combo box populated with the
values you want to select from. On the ButtonClick event for the
datagrid, you need to unhide the combo box, set its properties so that
it appears on top of the datagrid cell and then call the dropdown
method. Then, on the combo box Change event you need to populate the
combo box value back to the datagrid and hide the combo box. If you have
more than one button, you will either need separate combo boxes for each
or you need to set the rowsource in the ButtonClick event.
If you want, I can see if I can find the example but this should help
you get started.

James Barash


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Thursday, February 19, 2004 3:56 AM
To: dba-vb
Cc: accessd
Subject: [AccessD] DataGrid Buttons


To all,

Firstly, I’m a bit of a novice with the buttons on a datagrid.
Basically I can get the button to appear on a column, but don’t know how
to make it drop down to shown the letters A & N.  Also I need to make
sure that the user can only select from the list.  I have read up on the
Visual Basic help but it says to use a combo box as well on the button
click event, but there are no examples.

Can anyone help me out on this



Many thanks in advance for all your help.

Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a
month 
www.freeserve.com/anytime
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com