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 ClientInformation 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 ClientInformation 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 ClientInformation, hit continue to open form B, and it opens to the same record source as form ClientIfnormation.

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

Private Sub Form_Open(Cancel As Integer)
Me.ClientAutoID = Forms![frmClientInformation]![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 ClientInformation 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 ClientInformation 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 ClientInformation, hit continue to open form B, and it opens to the same record source as form ClientIfnormation.

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

Private Sub Form_Open(Cancel As Integer)
Me.ClientAutoID = Forms![frmClientInformation]![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.