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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.