copy form field values 2 another form

[vicsalt]

I have given up and need help

lets assume the following
i have 2 tables and 2 related forms
form 1 has the following fields: name, month, zone
form 2 has the following: month, zone, action

on the 1st form i have a button to open the 2nd form ( we will call it "add action")

what im trying to achiveve:

click button
form 2 opens and the fields "month" and "zone" are populated with the corresponding values from form 1.
i then simply add the action to the remaining field. close the form

resuly equals table two populated with all data for the record.

I understand this may not be the best solution but would like to see this work.

a example would be perfect.

thankyou

[pbaldy]

Open form 2 in data entry mode, right after that line:

Forms!Form2Name.Month = Me.Month
Forms!Form2Name.Zone= Me.Zone

using your actual form and control names. FYI, name and month are both reserved words (names of properties, functions, etc) so shouldn't be used as field names.

[June7]

I don't understand why you have two tables. Can each month/zone have multiple actions? Will each month/zone associate with multiple names?

You should be saving a single primary key value into second table.

Why don't you use form/subform arrangement?

[vicsalt]

once again someone doesnt answer the question

[vicsalt]

little more help , is this in the On load event

Private Sub Form_Load()
Forms!Form 2.Month = Me.Month
End Sub


i get error

[vicsalt]

Open form 2 in data entry mode, right after that line:

Forms!Form2Name.Month = Me.Month
Forms!Form2Name.Zone= Me.Zone

using your actual form and control names. FYI, name and month are both reserved words (names of properties, functions, etc) so shouldn't be used as field names.

little more help , is this in the On load event

Private Sub Form_Load()
Forms!Form 2.Month = Me.Month
End Sub


i get error

[pbaldy]

No, behind the button you mentioned. Plus as I said the lines I posted follow the line opening form 2.

[pbaldy]

In other words:

DoCmd.OpenForm "Form2",...
Forms!...
Forms!...

[June7]

There are several ways to pass values to another form.

1. form/subform arrangement - Master/Child links will automatically pass key value(s) to subform, key can be compound (point of my earlier post was an attempt to advise that with proper normalized data structure there should be no need to duplicate the two fields into second table)

2. first form fills in controls on second form (Paul's suggestion)

3. second form reads controls on first form

4. first form sets OpenForm method OpenArgs argument and second form reads OpenArgs property

5. first form sets global variables or TempVars which can be read by second form