Search results

I have a sequence of 7 cascading combo boxes. If I want to skip selection for the first (i.e.) 2 combo boxes and enter in data for the rest, it won't let me. I don't know how to write the cascading combo box VBA code that also includes telling Access a null/blank combo box to begin with is okay...

Re: How can query display info based on cascading combo boxes when box "isnull" I ended up doing: Field: [Category]=[forms]![frmIssue]![comboCategory] Or [forms]![frmIssue]![comboCategory] Is Null Criteria: True I didn't try your way, but that could work too. Thank you for taking the...

For anyone who needs this in the future, I figured out how to do this in the query. I set the Total (sigma sign) as an Expression then entered: BillingRate: [InvoiceSubtotal]/[QtyInvoiced] Simple enough. InvoiceSubtotal and QtyInvoiced were just titles of my other query/table columns that I...

I have a form with cascading combo boxes pulling from a table. They work perfectly, no worries. My problem now is if I do not enter information in every combo box (i.e. only two out of four combo boxes), how can I still run the query and get the appropriate information? For example (these are...

I currently have a query that pulls selected data from a table. There can be multiple rows of data, and two columns include dollar amounts and quantities. I have a total line going at the bottom so I can see the Grant Total of all the rows (for dollar amounts and quantity). Is it possible to...

Thanks, I'll check it when I'm on a different network. Work computer is blocking that site even though the Access question is for work! I'll let you know if I have any questions about your previous post.

I have a very simple cascading combo box form with three combo boxes. First - Customer - pulled from tbl1 Second - Item Description - pulled from tbl1, based on Customer Third - Quarter - not pulled from any table, just 1-4 numbers I manually inputted The cascading part works perfectly fine...

pbaldy - I looked up your link and from there found a code that might be more applicable to the multiple multiselect cascading listboxes, but I could be wrong. I entered in that code (and tried yours), but the Period turns blank once I begin to select the Platform Description. Here is the...

Hi, I am making a form at work for a coworker with cascading combo/list boxes where she can select a Customer, then Platform Description, then Period, then Year. I used VBA code for this and it's working perfectly - for single selection. I want to update this so she can select multiple...

That worked!! Thank you so much!! Am I able to check this as solved?

Hi, I'm slowly learning more Access and VBA, so I apologize in advance if I cannot specifically answer all your questions about this. Some background: I am making a form at work for a coworker with cascading combo boxes where she can select a Customer, then Platform Description, then Period...