Updating table from form...

[Ade]

Hi folks,

Probably a very simple question, but it's got me baffled (doesn't take much! )

Imagine this...

Asset list in a list box consisting of 1. Asset number 2. Description 3. Serial number 4. Employee name

Combo drop down box with employee names

I want to be able to "book out" multiple selected assets (selected in the asset list) to a particular employee (selected from the combo box).

I can get the list box & combo box populated but I'm struggling with how to update the table behind the list box.

Any ideas? Or do you need more info?

Cheers[/code]

 

[Ade]

Think I might be getting somewhere, but stuck with the following line of code, can't see what's wrong with it...

Set rs1 = dbs.OpenRecordset("SELECT * FROM tbl_data WHERE ([Asset Number]=[FORMS]![frm_booking].[List0]);")

1. rs1 has been declared as a recordset
2. dbs declared as dao.database and set to currentdb
3. tbl_data is the table where the list box (list0) is sourced
4. frm_booking is the form containing the listbox etc

Help!

Cheers