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: kenznpunky
- Order by date
-
Multiple Subforms - Can't assign value to object
Wow, I figured it out. First I used a function to assign the values; this worked, but it also got me thinking about my relationships. I had it a table between tables that I was trying to update. Oops! (It's been too long since I've used access). Anyway, now that I have that figured out I can...- kenznpunky
- Post #7
- Forum: Microsoft: Access Forms
-
Multiple Subforms - Can't assign value to object
Thanks everyone! I have tried many different things, and it hasn't worked. I am now working on using a module with a global variable instead, this seems to work. What is being assigned is part of a primary key, but not an auto-number. But I removed this, giving the table a different primary...- kenznpunky
- Post #6
- Forum: Microsoft: Access Forms
-
Multiple Subforms - Can't assign value to object
Hi, Thank you! The record source for the main form is just a table, 'dbo_Patient' Then I have sub_followup, SELECT [dbo_Pt_Followup].[Pt_Followup_ID], [dbo_Pt_Followup].[Pt_Followup_Date], [dbo_Pt_Followup].[Pt_Followup_Notes], [dbo_Pt_Followup].[Followup_ID] AS dbo_Pt_Followup_Followup_ID...- kenznpunky
- Post #3
- Forum: Microsoft: Access Forms
-
Multiple Subforms - Can't assign value to object
Hello, Can someone please give me some ideas? I have a form with 3 subforms. My main form is based on a table of patient data, and the subforms are based on this data plus different tables connected to that main table. I have patient & followup, patient & diagnosis, and patient & doctor. It...- kenznpunky
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
