About to pull my last hair....

[doran_doran]

If you want you can download the sample database from below.
http://www.dbforums.com/attachment.php?postid=3558791

We are in a business where we have to carry some data from year to year. so, lets say I have a table with bunch of fields. My tbl_groups has three primary keys (ga_number, plannum, pye) and has a auto number (ga_record_id).

I have another table (tblplanmatrix), where i put more info about a record. this table has a field called ga_record_id. which is same as tbl_groups ga_record_id.

When user goes to frmgroups and click on more info, the form loads another form call frmplanmatrix and show all the value from table plan matrix (tblplanmatrix).

But when user clicks on more info and there is not a record for that record in plan matrix table then the form creates one. it will create a record only if the user put some info on more info form.

Ok, here is wha i need your opinion.

I am carrying over some data to a new record and it works fine for table tbl_groups. However, for the same record i might have more info and i want to carry more info data to a new record but ga_record_id should match with the new record.

Another word, how do a form will know to grab the more info based on prior records.

Carry over form called "frmrollovera".

I am confused.

I do need your opinion.

Thanks
Dianna

 

[Travis]

OPENARGS

Pass the id in the Openargs for the frmplanmatrix Form.

This is a Parameter of the Docmd.OpenForms function.

 

[doran_doran]

How do I utilize openagrs?

But there are two tables.

tblplanmatrix should have new ga_record_id_2 (but similar to just like tbl_groups) and being able to copy the year before information.

I feel like i did not make sense. Let me know if i sound confusing.

Regards
Dianna

===========================================
If Me.OpenArgs = "GotoNew" And Not IsNull([GA_Record_ID_2]) Then
DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70
End If
===========================================

PS: Have you seen the database. what do u think? Is it doable? like create a new record in one table, then write the auto number from this table to plan matrix table, then copy last yr plan matrix to newly assingned record.