Search results for query: *

I Have 2 dependent combo boxes Product & Group on a form Factura details. Each are bound to tbls Products & Groups. The Row source are set as follows Product SELECT Products.ProductID, Products.ProductName FROM Products ORDER BY [ProductName]; Group SELECT Groups.FamilyID, Groups.Family...

To everyone that has helped me thanks. I have not quite solved my problem but thanks to you all I feel that I am almost there. Just something minor that I am doing wrong.

Thanks Ginger but the combo boxes are on a sub form and the command button is on the main form and I don´t know how to reference the code on the main form to the sub form

Thanks for replying, Ginger in the code what do I put for Combo1 and Combo2? Ken, After trying what you said I get run time error 13 type mis match. Any suggestions?

Yes was a bit vague. The two combo boxes are based on two tables group and title and the code for them is Private Sub group_AfterUpdate() Me.Title.RowSource = "SELECT TitleName FROM" & _ " Title WHERE GroupID = " & Me.group & _ " ORDER BY TitleName" Me.Title = Me.Title.ItemData(0) The...

I have two synchronised combo boxes. Sometimes I want to print a report with nothing in the 2nd dependant combo.But if I leave it blank the whole report appears blank. How do I overcome this?

I have 2 synchronized combo boxes named group & Title. The synchronize works perfectly using Private Sub group_AfterUpdate() Me.Title.RowSource = "SELECT TitleName FROM" & _ " Title WHERE GroupID = " & Me.group & _ " ORDER BY TitleName" Me.Title = Me.Title.ItemData(0) End Sub I want to...

I have an invoice report that prints from a query base on a table. I input details from a form based on the table. The report details are printed in what seems to be a random order from the form input. How can I get the report to print the details in the same order as on the form.