Add new record, pass two fields

[Xtremlylost]

I have searched for this but cannot find exactly what I am trying to do. I have a (Complaintfrm) which I use to log various complaints. On occasion I need to file a claim relating to the complaint. I want to add a command button to the complaint form that will open the claimfrm and add a new record for the specific complaint carrying the [ComplaintID] and [Carname] with it. The primary key in the claimfrm is an autonumber field which should generate a new number when the two fields are transferred.

I can easily use the wizard to set a link between two forms to find related records (Which has been answered in the FAQ's but this is not what I need to do). There will not be a related record in the claims table as this is a one to one relationship between the specific complaint and possible claim. I really cannot add the claim info at the bottom of the original form due to needing large type for a couple of the employees that will be using the dbase. If I can get the claimfrm to work as described then it would be easier for all involved.

Thanks in advance,
Any help will be greatly appreciated.
Xtremelylost

 

[JoanneM]

Firstly the differing size for the scree can be overcome by putting a page break on your form thats the tool bar button that looks like two pages with an arrow pointing to the space between - this will then give you the chance to have the one form with two screens

Secondly in the past I have known one complaint to generate more than one claim that being the case you may possibly need to rethink your one to one relationship.

Thirdly if you want to open the form and form the link open the form adding a new record and set a global or form variable to the complaint id - set the complaint id on the claim form to the variables value and there you have your link.

NB if you did go down this route remember to see if the claim form is .dirty on close and if its then delete the current record or you will end up with blank records.

HOpe this is what you mean

jo
claim tbl with complaint id