Datagrids

[jscontreras]

Hi All,

Does anyone know how I can implement a datagrid into a form? What I'm trying to do is provide the user a spreadsheet type interface where they can add/edit/delete records within a grid. Help would be appreciated.

Thanks

 

[Atomic Shrimp]

If I understand you correctly, what you're looking for is the equivalent of an updatable crosstab query; unfortunately this isn't possible - the bes compromise I've come up with is to use a datasheet subform and an associated combo box so that the user can first choose which part of the data they want to edit (in my case the store location) and when they have selected, the datasheet displays the detail records (in my case the products in stock) for that store.

Hope this helps

Mike

 

[jscontreras]

Thanks, but I'm not looking for a x-tab query solution. I'd like to know if there are any activeX controls such as a datagrid that might be used and some code examples.

Thanks

 

[Atomic Shrimp]

I'm not exactly sure what you mean by a datagrid; if you want something that looks a lot like a spreadsheet, then a datasheet form is pretty good.

 

[jscontreras]

Hi Mike,

a Datagrid is very similar to your solution, however I have more methods and properties available to me. However if I can't find any topics on this, I'll follow your suggestion.

Thanks