Hi,
I've seen the datagrid control on my "other controls" in my access toolbox, but for some reason when I'm trying to add it now it won't apear in the list!
Which reference should I add to be able to view it?
Thanks for your reply.
The problem is that the subforms must be bound to a datasource if not you'll only be able to add one record.
I am currently building a "wizard" for adding new orders. I'm planning to use the data grid for the order details, however, I want to first get all the data and then add it to the database through an insert query (for validation purposes). If I use a subform I can't add records to it.
The workaround is to use a temp table and bound the data to a templ table, but since I'm working with access projects in a multi user environment on citrix that is not an option. I can use sql server temp tables but that would be my last option since they are hard to work with on the application level.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.