passing values between tabs in a tab form

[joyaccess1]

Hi,

I have a situation where the fields of a table are in 2 tabs in a form, i need to know how can i pass the data entered in form tab1 to the form tab2.

also, since the fields of a table are divided in 2 tabs in the form, when i enter data in tab1 and click on tab2 the form tries to insert data in the table and gives an error that some of the fields have no data. how to resolve this error ?

any help will be appreciated.

Thanks
Joy

 

[boblarson]

also, since the fields of a table are divided in 2 tabs in the form, when i enter data in tab1 and click on tab2 the form tries to insert data in the table and gives an error that some of the fields have no data. how to resolve this error ?

You aren't using subforms by chance.

 

[gemma-the-husky]

you dont need to pass values between tabs in a form (unless as bob says one of the tabs contains a subform)

tabs are (effectively) just holders on a form for other controls, and the data sources are all taken from the forms underlying query

if you want the same field to be on two tabs, just but it there - if you change the value on tab_a, it will automatically change on tab_b also

 

[joyaccess1]

yes, the form tabs are a subform, here is an example what i am doing

tab 1:
name
age

tab 2:
name
address
other fields

so when i enter the name and age in "tab1" and then click on "tab 2" i get the message that other fileds in the table are blank (as it is trying to insert the row), what i need is when i click on tab 2 the name from tab1 should appear in tab 2's name ...... and it needs to insert a rows after i am done entering data in tab2..... is this possible in access 2007 ?

Thanks
Joy

 

[boblarson]

If this is all from the same table, then don't use subforms like gemma had mentioned. If it is different tables, it is telling you that you have required fields in the table that the first tab is tied to that need to be filled out before you can move on to another recordset because when you move between forms, it will try to save the record in the one you are just leaving and if the data is not complete (based on how you defined it in the table) then it won't let you do it.

 

[joyaccess1]

Thanks, will not use the sub-form then, thanls for the help & inputs.

Thanks
Joy