Search results

https://www.access-programmers.co.uk/forums/threads/a-multi-select-form-using-unbound-check-boxes.323395/ This solution works pretty well. Thank You @CJ_London Only issue is, I keep getting a Runtime Error 424 after selecting a record:

Good day again everyone, I'm attempting to implement your solutions. I'll let you know as soon as one works.

no no, still appreciate the idea

The reason I want to achieve something like this is to bulk mark desired invoices as paid

Thanks for your suggestion. However they don't look very nice.

Good day everyone, Just a quick one. Is there a way to select a specific record based on the selected radio button on a continuous form? I know that the radio buttons has a different option value. I think making them unbound is the way to go? All I basically want to achieve is when the...

Thank you for taking the time to reply. When I select the Relational Combo box on the parent form (referencing JobT), it inserts the value in the corresponding field of the InvoiceT. Thereby linking them together. The Yes/No field was just a means for me to know if the particular record had...

Hi @arnelgp You sir, are a legend. I've been searching the web for hours. Thanks again for everyone's input.

Good day everyone. I have an Invoice form with a subform on it pulling records from another table (JobT) pertaining to the PK. The TicketNumber on the Invoice form is a Relational Combo box that runs off of a query. It essentially filters the JobT for records marked as Completed. Is there...

Thank you for your input.

That's perfect thank you! Sorry must of misclicked.

Thanks for your response. Job invoices pull values from tables whereas Sales Invoices capture new invoice related data directly to the Invoice table

Good day everyone, Does anyone know any way (VBA or Function) to select a "option" and then based on that selection open a desired form. Example: Thanks!

Correct

The 3 subforms on the report and linked via the primary key, TicketNumber, of the Invoice table. As such, when there are records in each of the tables that reference the TicketNumber they populate data. This all works perfectly fine in Report View (Fields in red are Invisible SUM fields)...

Thanks for the idea. I tried that. The physical subform (containing no data) disappears when Report view is switch to Print preview. So for example, InvoiceJobRSF3 will disappear and then the calculated field can't pin down the data and essentially breaks. The Nz function wont Null a...

Good day everyone, I have a Text Box at the bottom of my report called Subtotal, which acts as a calculated field: =[InvoiceJobRSF1].[Report]![LabourTotalSum]+[InvoiceJobRSF2].[Report]![CostTotalSum]+[InvoiceJobRSF3].[Report]![TravelTotalSum] InvoiceJobRSF1, InvoiceJobRSF2 & InvoiceJobRSF3...

Appreciate the Idea. Sadly no dice. Report View is perfect but Print Preview isn't happy. I know it has to do with the missing Subform because when there is records in it, it works:

Thank you for your advice. Isn't there a simpler method of rectifying this rather than creating queries etc? I mean it's working perfectly fine in Report View and Layout View. Just not in Print Preview. I can see why Access is confused, the empty subform disappears when Print Preview is...

Currently nothing, just grasping at straws to be honest.