Saving record and clearing form

[CanWest]

I have a command button that i need to be able to save the current record in a completely different form and then start a new record in that same form.

I tried

Forms!hfrm_PerSerOrgSerAssoc.Form.NewRecord

but that did not work. Can anyone assist me with this one

Thanks

 

[John Big Booty]

What's the relationship between the two forms? Is your first form bound to a table? How about your second form?

 

[CanWest]

What's the relationship between the two forms? Is your first form bound to a table? How about your second form?

There is no relationship between the forms but both are bound to separate tables.

 

[missinglinq]

Records aren't saved in forms, they're saved in tables. Data is only displayed in forms.

Are you saying that you want to save the current record in the table that your first form is based on as well as in the table taht your second form is based on? And if so, why? Storing identical records in multiple tables violates one of the cardinal rules of relational databases.

Linq ;0)>

 

[CanWest]

Records aren't saved in forms, they're saved in tables. Data is only displayed in forms.

Are you saying that you want to save the current record in the table that your first form is based on as well as in the table taht your second form is based on? And if so, why? Storing identical records in multiple tables violates one of the cardinal rules of relational databases.

Linq ;0)>

They are not identical records. They are two separate forms based on two separate tables. On the save command button in the first form I have placed several 'setvalue' commands that update the second form. I need to save the current record that is displayed in the second form and then clear the second form ready for the next record.

 

[John Big Booty]

Won't simply going to a new record do all that

 

[CanWest]

Won't simply going to a new record do all that

I believe so but how do i tell the second form to go to a new record. I tried the code at the beginning of this post but it did not work

 

[John Big Booty]

Try;

DoCmd.GoToRecord acDataForm, "YourFormName", acNewRec

 

[hk1]

To do what you're trying to do I would normally create a sub or function on the "other form" (the one you want to do a save on) that handles the save and then call it from your first form.

Public Function SaveFormData()
     DoCmd.RunCommand acCmdSaveRecord
End Function

'I'm assuming you want to do the save on a main form, not a subform
'Here's how you call the Function named SaveFormData
Call Forms("frmMainFormName").SaveFormData

 

[hk1]

As is obvious, I was a little late posting. My idea still applies. You just need to put the GoToRecord code in the function SaveFormData, or whatever other code you want in there.

 

[CanWest]

Try;

DoCmd.GoToRecord acDataForm, "YourFormName", acNewRec

That Worked Perfectly

Thanks