Multiple Tables & Forms - linked together

[robertmeyer1]

Hey,

I have about 5 tables, and each table has a corresponding form. The 1st table (A) is a client data table (client information) with a ClientID (PK). This clientId is a (FK) in all 4 other tables (B-E). Now I have the tables linked in a relationship by PK-FK (1-to-1 relationships). The forms are set to go form A to form E by use of command buttons (click on in form A and opens form B...). The issue is, when I enter data in form A then click on the "continue" button to form B, the clientID is not displayed on form B. Instead a blank form B is opened, where I can enter the data, but it is not linked to form A. I've tried using the "where" condition on the OpenForm. Setting TableA.ClientID = TableB.ClientID ; but this doesn't work either. Instead after entering data in form A and clicking on continue it pops up the MSG: Enter Parameter Value TableB.CLientID . I don't understand why the clientId is not being carried over to tables B-E. Can someone please advise me on this. I simply can't figure it out. Thanks.

[MMcCarthy]

Hey,

I have about 5 tables, and each table has a corresponding form. The 1st table (A) is a client data table (client information) with a ClientID (PK). This clientId is a (FK) in all 4 other tables (B-E). Now I have the tables linked in a relationship by PK-FK (1-to-1 relationships). The forms are set to go form A to form E by use of command buttons (click on in form A and opens form B...). The issue is, when I enter data in form A then click on the "continue" button to form B, the clientID is not displayed on form B. Instead a blank form B is opened, where I can enter the data, but it is not linked to form A. I've tried using the "where" condition on the OpenForm. Setting TableA.ClientID = TableB.ClientID ; but this doesn't work either. Instead after entering data in form A and clicking on continue it pops up the MSG: Enter Parameter Value TableB.CLientID . I don't understand why the clientId is not being carried over to tables B-E. Can someone please advise me on this. I simply can't figure it out. Thanks.

If form A remains open when you open form B.

In the OnOpen event of form B put

 
Private Sub Form_Open()
 
Me.ClientID = Forms![Name of Form A]![ClientID]
 
End Sub
 
 

[robertmeyer1]

I have 2 forms, based off separate tables. Form ClientInformati on is entered, then you click a command button (running macro) which opens Form B. I am trying to set the clientautoId the same. This is the autonumber from ClientInformati on and is used to uniquely identify the client in all the tables. (these 2 tables have a 1-to-1 relationship). The goal is to enter the information in ClientInformati on, hit continue to open form B, and it opens to the same record source as form ClientIfnormati on.

Here’s the code I was recommended to use (from form B’s OnOpen):

Private Sub Form_Open(Cance l As Integer)
Me.ClientAutoID = Forms![frmClientInform ation]![ClientAutoID]
End Sub

Error Message that pops up:

Microsoft Visual Basic:
Run-time error ‘-2147352567 (800200009)’:
You can’t assign a value to this object.

It highlights Me.CLientAutoID . When I move my cursor over both ClientAutoId’s it shows the clientautoid number’s for the specific record. (ex: 11aaa1111 is used on both id’s). Any suggestions?

[MMcCarthy]

Is ClientAutoID an autonumber in both tables?

It should only be an autonumber and primary key of one table.

It should be a number and foreign key in the other table.

I have 2 forms, based off separate tables. Form ClientInformati on is entered, then you click a command button (running macro) which opens Form B. I am trying to set the clientautoId the same. This is the autonumber from ClientInformati on and is used to uniquely identify the client in all the tables. (these 2 tables have a 1-to-1 relationship). The goal is to enter the information in ClientInformati on, hit continue to open form B, and it opens to the same record source as form ClientIfnormati on.

Here’s the code I was recommended to use (from form B’s OnOpen):

Private Sub Form_Open(Cance l As Integer)
Me.ClientAutoID = Forms![frmClientInform ation]![ClientAutoID]
End Sub

Error Message that pops up:

Microsoft Visual Basic:
Run-time error ‘-2147352567 (800200009)’:
You can’t assign a value to this object.

It highlights Me.CLientAutoID . When I move my cursor over both ClientAutoId’s it shows the clientautoid number’s for the specific record. (ex: 11aaa1111 is used on both id’s). Any suggestions?

[robertmeyer1]

It's a FK and a number. It think I'm gonna try to start over.