Need to pass a value from one form to another

[Cedarguy]

Help please.

I have a Form (datasheet) based on a query; the Form lists tasks
Each entry has a button beside it which is used to create a follow up task
I am able to open a new Form using the button via a macro but can't figure out how to pass the "account id" so the follow up task is created for the same account
I tried using temporary variable in the macro but obviously need help as the value isn't getting through.

Thanks

[June7]

The easiest approach is form/subform arrangement. Otherwise need code and there are several ways to do this. I use only VBA. Code in the second form Current event:

Where does the AccountID come from? Is it somewhere on the first form?

If Me.NewRecord Then
Me!AccountID = Form_firstformname.AccountID
End If

[Missinglinq]

...I have a Form (datasheet) based on a query...

...Each entry has a button beside it which is used to create a follow up task...

I run v2007, but I like to keep up on the new things with versions 2010/2013, so I have to ask...are Command Buttons now available on Datasheet View Forms?

Linq ;0)>

[June7]

Good catch, linq, I missed that.

No, they are not with 2010.

[Cedarguy]

I run v2007, but I like to keep up on the new things with versions 2010/2013, so I have to ask...are Command Buttons now available on Datasheet View Forms?

Linq ;0)>

Sorry, that was my mistake. I should have said "multiple items" form instead of datasheet.

[June7]

Does suggestion in post 2 resolve issue?

[Cedarguy]

First, thank you for your reply.

The account id is on the query behind the calling form. BTW, I got the macro working with tempvars; it appears I wasn't replenishing it in the called form.
I'm not too proficient with VBA so try to stick with the canned solutions as much as I can.
Now I'm stuck on date. Using tempvars, I want to take the date on the calling form and make it 90 days hence and store it on the called form; should be simple but I'm limited by syntax issues.

Thanks.

[June7]

Set a TempVars for the date with expression: [date field] + 90

What syntax issues?

[Cedarguy]

Too embarrassed to mention the stupid mistake I made. Thank you again. I'm good for now