help... append query

[quasimodo]

i got a form (in attached pic). The vacant rooms part (circled red) is part of the main form, and the customer part (circled blue) is a subform of another form.

I need to be able to take the CustomerID from the subform, and the RoomNumber from the main form and add them to a Bill table. I have tried an append query, which is also on the pic, and that doesnt seem to work... Is it possible to make an append query which can do what I need, and how would I make an it?

Thanx in advance

 

[Pat Hartman]

The append query that you built will not work because there is no way for it to relate the selected items by joining the two queries. You'll need to build the append query in VBA so that you can use a "literal" values append to append a single row. The alternative is to use the .addnew method. Both examples can be found in help or here by searching the archives.