Automation Object Error

[acog1]

Hi everyone, I know that there is a question similar to this already posted but the answer to it does not really seem to relate to my problem! So here goes...

I have a main form which has a tab control that links a number of other forms together, if the information is already in all of the corresponding tables then everything works fine but if I am entering new details then I am getting an error in 2 out of my 7 tabbed subforms.

The error I get is 'The object doesn't contain the automation object Registrations' - You tried to run a Visual Basic procedure to set a property or method for an object. However the component doesn't make the property or method available for automation operations.

I have checked the VB code behind the form and there isn't any, this doesn't happen when I click on a button of any sort as there aren't any and there are no event procedures on the form. It happens when I attempt to enter data into the child link field.

To be honest I know it's a mistake I have made as I am no expert in Access, all my tables are linked though I wont guarantee that they are all correct though someone has looked at this for me and told me they are.

What I was trying to achieve was that the primary key would extract details such as surname and first name and place them in every form as soon as the primary key is inserted, the problem is that I have the same primary key in every table and when inserted in one table it is not updating the others, so when I attempt to insert it on one of the other forms I am getting the above error.

Any help would be really appreciated as I have rebuilt this database three times now and keep getting the same problems but with different error messages and I am now really pushed for time to get it finished.
Thanks in advance

acog1

[JConsulting]

Hi everyone, I know that there is a question similar to this already posted but the answer to it does not really seem to relate to my problem! So here goes...

I have a main form which has a tab control that links a number of other forms together, if the information is already in all of the corresponding tables then everything works fine but if I am entering new details then I am getting an error in 2 out of my 7 tabbed subforms.

The error I get is 'The object doesn't contain the automation object Registrations' - You tried to run a Visual Basic procedure to set a property or method for an object. However the component doesn't make the property or method available for automation operations.

I have checked the VB code behind the form and there isn't any, this doesn't happen when I click on a button of any sort as there aren't any and there are no event procedures on the form. It happens when I attempt to enter data into the child link field.

To be honest I know it's a mistake I have made as I am no expert in Access, all my tables are linked though I wont guarantee that they are all correct though someone has looked at this for me and told me they are.

What I was trying to achieve was that the primary key would extract details such as surname and first name and place them in every form as soon as the primary key is inserted, the problem is that I have the same primary key in every table and when inserted in one table it is not updating the others, so when I attempt to insert it on one of the other forms I am getting the above error.

Any help would be really appreciated as I have rebuilt this database three times now and keep getting the same problems but with different error messages and I am now really pushed for time to get it finished.
Thanks in advance

acog1

You have a refresh problem. Chances are all you need to do is set up a case statement.

you would put this on your tab control's change event.
J

Private Sub MyTabControl_Change()
Select Case Me.MyTabControl.Value
Case 0 'first tab
MsgBox "refresh subformname here"
Case 1 'second tab
MsgBox "refresh second tab subformname"
End Select
End Sub