Do you have any example from the project? Please share so it can be more precise.

Keep the Public Variable declaration separate from the Main Dashboard Form in a Module with "Option Explicit" and keep the rest of the code from the O...

I have tested that after logging in, the Dashboard Navigation button highlights in the Main Dashboard form, and pressing the Enter key repeatedly does...

Sales Process includes, Sales Order, Sales Invoice, associated with the Customers, deduction in the Inventory, and the addition in the Accounts Receiv...

Here is the solution as you might have already observed in the V12 file. It should be helpful for others. If Me.Form.Recordset.RecordCount <> ...

@arseyguy I think, I got your point and have a suggestion for you to use a List box and a subform within a single form. The list box can contain multi...

That sounds a clear picture of grouping, the idea and efforts are appreciated. Contact info would be better in place of just a Phone Number.

@arseyguy It is fine, if you are not willing to open a form in dialog mode. If you want to open multiple forms within a single form based on multiple ...

You are on Auto mode. Glad it resolved.

First of all, there is no need to create a separate query to get the count of OrderIsInvoiced. It is a numeric(Integer) type of field and you are usin...

@arseyguy Why you are not opening a form in dialog mode after clicking on the phone number rather than to use "browse to"? Even you succeed, how you w...

Hi there, I have showed you the simplest way, killed two birds with one stone. It means while selecting the customer from the drop down, data has alre...

Thanks for sharing this wonderful information. I have tried different methods including the one you have described. You know the indication of typical...

There was a missing comma in the previous post. Let me explain DoCmd.BrowseTo acBrowseToForm, "CustomerMain", , "CustomerID=" & Me.CustomerID ...