Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Notifications
Clear all
Nov 10, 2024 7:42 am
Sorry i couldn't reply on this coz i was hospitalized for 1 week. Yes i added missing comma and the form view is single form. But still it doesn't work. It works well before using navigation form. But after Navigation form it doesn't work. I have posted screenshots so that you might have idea what i'm trying to explain. Please Help Me.
Nov 10, 2024 7:43 am
Nov 12, 2024 6:14 am
Please help me with my project as I'm struggling using this navigation and now at the end I'm planning to drop the idea of using navigation. Please suggest me...
Nov 20, 2024 1:24 am
@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 will get back to the subform.
Nov 20, 2024 7:17 am
@ursh Yes I have kept that as my last option, but still a hope if docmd function works then i don't have to open form in a dialog mode Coz i need to open more forms after this process, it will looks dirty.
Nov 28, 2024 4:28 pm
@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 criteria like the Phone Number, you can do it by integrating multiple subforms within a single main form and all the subform can be controlled by multiple criteria as well.
I think you get my point.
Dec 10, 2024 8:12 am
@ursh I think this is what you are trying to explaining open within the subform. I got this issue while searching with two different way. One through running search and double clicking the phone number and Searching through Text box typing.
Please check these attached picture and Please help me with the solution .
Dec 10, 2024 8:15 am
I'm expecting this result as it opens inside the subform, and main form search boxes are visible. This result is after double clicking the phone number from the list. But if i Search phone number by typing inside that text box, it opens within that main form and covers the search boxes which i don't want it.
Dec 10, 2024 8:17 am
This is my issue after searching the phone number by typing inside the text box. It opens the form but in that entire area and covers the main form and it's search boxes. Please help me if it it possible to open like double clicking the phone number within that subform and open it inside that subform.
Dec 11, 2024 2:28 am
@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 multiple columns for the customer and can be filtered from the top textboxes as well. Now you can click on the customer from the list box and the subform will be filtered.
This is the best way to have a list of customers with filter option and a subform side by side to filter the selected customer.
Dec 15, 2024 5:20 pm
Nov 20, 2024 4:26 am
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. If you can copy past the code that is preventing the task from completing successfully, into your reply comments. Just use the <> "CODE" symbol in the menu bar above. It can be tricky as Ursh said; however, it is not impossible! Stay positive. Try the dialog approach first, as it is actually the best means to go to and from a complicate form like you have there.
Nov 20, 2024 7:25 am
This is the code i'm using but it opens within that subform as a blank "White"
Private Sub Phone_DblClick(Cancel As Integer)
DoCmd.BrowseTo acBrowseToForm, "CustomerMain", , "CustomerID=" & Me.CustomerID
End Sub
And i applied Below Code in Customer ID (Double Click Event), It opens within the navigation form but it just shows the first records only. Not the specific records of Customer ID Criteria.
DoCmd.BrowseTo acBrowseToForm, "CustomerMain", "MainDashBoard1.NavigationSubform", "[CustomerID]='" & [CustomerID] & "'"
Please suggest if this is possible or not, If not then As per @Ursh i have to open form in a dialog mode. Thanks in Advance
Nov 20, 2024 8:43 am
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 information based on a where statement for Customer ID instead. Opening in a dialog mode (as Ursh suggested) will allow you to return back to the originating form as it never closes, unless you ask to of course. The browse to does work if you want to leave the tab where you currently are and go to another control tab. Sorry, but I can’t find another means to do what you want to in this case.
Nov 21, 2024 6:21 am
Thank You For Giving Time On My Project and suggesting Me. I'll be doing what you guys have suggested. I might need your Help in future to complete my project. I'll be posting if something occurs.
Page 2 / 2
Prev
