Web Development

Ask something
Discussion Locked

Access like table in VB6

0 helpful
3 replies

by craig shepherd 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In Access I can use the lookup wizard and I get a combo box for that field.

Is there any way to do this with the DataGrid or is there a thrid party control that will let me do this in VB6?

3 replies

by andrew

You can do this with the standard VB combo box. The simplest way is to add a Data control to the form (setting its DatabaseName & RecordSource properties to point to your Access DB & Table), then set the DataSource property of the Combo to the name of the Data control. This will bind the Combo to the Access table, automatically populating it.

Many other VB controls (including the DataGrid) can be data-bound in this manner.

This method is simple, but not flexible. I prefer to write ADO-based methods for populating controls like combos.

This discussion is closed to new replies.