subforms and tab control

[Muzicmn]

i have a db that consists of 5 small tables that are all linked together with an id# (autonumber)

what i am trying to do is create a dataentry from using tab controls that will allow the end user to click on one tab to enter health information and click on another tab to enter attendance information. My questions is, is there a way where i can use a combo box, whether on tab one or on a header of some sort that will not only populate all pages in my tab but also relate them all so whatever info is entered in each tab page automatically stores the id# in the appropriate field for that table

thanks

Ricky

 

[Muzicmn]

never mind i think i figured it out

thanks anyway

Ricky

 

[daisyage]

hey ricky,
sounds like i am working on something very similar. i am collecting demographic info and test results for patients. each test is a separate subform on it's own tab page. i can view all the records, it looks like my fields are linked correctly, but when i try to add a new record, i get an error, "ambiguous name detected: find subject_click". have you run into anything like this before? i went into VBA, which i hesitate to do b/c i am not a coder, but i can't see anything unusual.
anyone have any ideas?
appreciate any help!

 

[daisyage]

posted, then searched...

i had duplicate code... i just searched the forum and found the exact problem listed...happy to figure it out!!! cheers!