Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DataGrid control in msaccess

Status
Not open for further replies.

AppDev76

Programmer
Jun 8, 2004
65
US
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
 
Why do you want to use a data grid control on an Access form?

Have you looked into a continous subform?

-Gary
 
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.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top