Writing Data from One Table to Another with VB
Take a look to the VB help in the DBCombo control, or try in the
McMillian personal bookshelf (www.mcp.com) there are books in VB 5 and VB 6
dealing with this topic.
Quote:
>I have 2 Access tables, one for User Names and the other for their work
>schedules. The tables are related by a unique ID number. I am populating
>the DB combo box with the user names from the user table. Is it possible
to
>have VB take the ID from the the User Names table and enter that number
into
>the ID field in the Schedule table? I don't know how to take a field from
>one table and write that value to another table!
>Thank you in advance,
>Zach
