one to one tables in subforms

[hwdoyle]

hello,
we collect around 200 pieces of data for each client in our database. the data has been split up into five tables which are in a one to one relationship with eachother.

my main form has a combo box which selects the client to work with, which changes the current record in my main client table. i have a tab control with five subforms for entering data. these subforms have their navigation buttons turned off, so that the user can only browse records using the navigation buttons of the main form. so i am not using the main form for any data entry, just navigation.

i'm having a weird problem that crops up sometimes while trying to add records. i will try to enter data in the first field in my first subform, and i get the error that i've tried to assign a null value into a variable that isn't variant. sometimes it adds the record, sometimes it doesn't. i will look into that a little more closely.

now my main form has a combo box record selector. i think my problem might be when i enter data into the subform, it makes the new record and then it's not able to link back up with the combo box record selector in my main form because it doesn't exist in the main form yet. how do i get the thing to refresh once a new field has been entered via the subform?

i will also point out that the main form gets its data from my main client table, and so does my first tabbed subform.

does anyone see what my problem is?

thanks!
harry

 

[Krij]

Try to do a refresh of controls on open form directly in your code after entering new data:

Forms!frmMain.Combobox.requery

You may also see if you can update the combobox when clicking the tab for the form

hello,
we collect around 200 pieces of data for each client in our database. the data has been split up into five tables which are in a one to one relationship with eachother.

my main form has a combo box which selects the client to work with, which changes the current record in my main client table. i have a tab control with five subforms for entering data. these subforms have their navigation buttons turned off, so that the user can only browse records using the navigation buttons of the main form. so i am not using the main form for any data entry, just navigation.

i'm having a weird problem that crops up sometimes while trying to add records. i will try to enter data in the first field in my first subform, and i get the error that i've tried to assign a null value into a variable that isn't variant. sometimes it adds the record, sometimes it doesn't. i will look into that a little more closely.

now my main form has a combo box record selector. i think my problem might be when i enter data into the subform, it makes the new record and then it's not able to link back up with the combo box record selector in my main form because it doesn't exist in the main form yet. how do i get the thing to refresh once a new field has been entered via the subform?

i will also point out that the main form gets its data from my main client table, and so does my first tabbed subform.

does anyone see what my problem is?

thanks!
harry

 

[CEH]

First thing I would look at is "five tables which are in a one to one relationship with each other"...........