OMG, I forgot to adjust my column count and sizing for 7 columns in the combo box properties. All i working fine now....always the simplest things, e...

Addendum: When I change the command code (see below) all the fields populate with the City Data. Is there a restriction against for more than 4 colu...

From what I know about the BrowseTO function this is not the correct intent. Highly suggest you open a single form that presents the customers inform...

I would love to try and help, but to be honest I cannot discern from your screen shots as to what you are doing and how you have coded the process. I...

Had to change the 1 to a 0 to count "Not Invoiced" worked great. I actually went to a level in my sandbox project of creating a separate query for ea...

Nice to see memberships growing.

Yep, Customers is a copy from Suppliers, so I do not know what is intended to be shown on that form. Suppliers looks like we have to wait for invoici...

I have to laugh, otherwise I will cry. I did create a q_Orders using the SQL that you used as the record source for the form and it worked. Can I ju...

Thank you Ursh, I see that clearly. I had messed up my coding so bad I could not figure what was happening. Fixed that one, found another coding probl...

Eureka! afte3r another two hours, I worked it out. Not even sure what I did except I created new controls for each field versus adding from existing ...

Okay, here is a working sample of the sorting function. Give it a whirl and let me know what you think. NOTE: You must extract the zip file to yo...

Here is the code I used. I used the same code for each button, making sure I edited each one appropriately. As you can see it works quite well. Enj...