Search results

gahhh NO idea why it is not working...either the subform appears for all invoices (and is blank for those where the criteria is not met) or it doesn't appear for ANY invoices (even those where the citeria is met).... so I have decided to create a button called 'verify account' which can show my...

This is what I have Private Sub Main_Contacts_AfterUpdate() If Not IsNull(BillAddress_Addr1) Then Me.qrySalesRepByDate_long_UNPAID.Visible = True Else: Me.qrySalesRepByDate_long_UNPAID.Visible = False End If

ok I have it working when I press a button...but I'd like it to work when the page loads up..I tried changing the criteria to 'on load' 'on change' 'on focus' ect..and nothing happens sadly..

thanks, working on it...seems iffy...either the popup appears all the time or doesnt appear at all. Does the code you wrote need to be entered in the form or subform?

Ceh That sounds like it could work however I'm not that well versed in writing code to do it.

I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice. So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page...

after clicking on the date how do I get the seleted date to be entered into a field in a form I am interested in? ie. field 'DueDate' in form 'purchaseorder':confused:

Form CEH, Yes, it does seem odd...but I am taking data from Quickbooks and converting it into access, plus the specs needed for my client are very specific..so I need to have those fields update in such a way. Basically I need to know if an autoupdate button can have criteria limitations, I...

thanks! That worked like a charm...another question: Can I do the same thing with a sub_form? I'd like a button that can update date from the parent form to the child form where the joined fields are: Masterfield = Name Childfield = BillAddress_Addr1 The two tables being used are...

Hi all, I tried looking for an answer to this but I haven't found anything yet. I have a form that features a 'Bill To' and 'Ship To' section with 'City, State, Zip etc..' for each one. I'm triyng to create a button that my users can press to automatically copy the data from 'Bill To' into the...