Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KennyCaudill
- Order by date
-
"On Click" code to go to record in main form
PERFECT, IT WORKED! Exactly what I needed. Thanks so much. I made a database 10 or 11 years ago and lost the code to it 5 years ago. Only have and mde file and the back end data files. It was getting too old and I wanted to do things differently. So I am starting all over again. Thanks...- KennyCaudill
- Post #8
- Forum: Microsoft: Access Forms
-
"On Click" code to go to record in main form
I have attached a screen shot of my form. Just created it today and only entered 2 names for testing. I want to click on any last name and have the main form go to that name. Thanks, Kennyhttp://www.kcphoto.com/xxxMisc/FormPic.jpg- KennyCaudill
- Post #6
- Forum: Microsoft: Access Forms
-
"On Click" code to go to record in main form
I tried your suggestion. Here's the code: Forms!Clients.Recordset.FindFirst "[CLIENTS KEY] = Me![CLIENTS KEY]" It gave an error saying: The Microsoft Access database engine does not recognize 'Me!CLIENTS KEY' as a valid field name or expression. This is the Primary Key field for this table...- KennyCaudill
- Post #5
- Forum: Microsoft: Access Forms
-
"On Click" code to go to record in main form
The main form does have the client's name. The main form shows one record. The subform shows all clients names down the right hand side of the form. I want to click on a name in the subform and have the main form go to the record for that name. I'm listing all my attempts to try to clear...- KennyCaudill
- Post #4
- Forum: Microsoft: Access Forms
-
"On Click" code to go to record in main form
I just tried this and it didn't work: DoCmd.GoToRecord acDataForm, "Clients", acGoTo, Forms!Clients.[Clients List subform].CurrentRecord Run time error 438 "Object doesn't support this property or method" Kenny- KennyCaudill
- Post #2
- Forum: Microsoft: Access Forms
-
"On Click" code to go to record in main form
I haven't used Access for about 10 years and I just started a new database with Access 2007. I have a clients form and have added a subform with all names from the same table as the main form. I want to click any name and have the main form go to that record. I know I'm being lazy, but could...- KennyCaudill
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
