Command Button Help

[msday]

New to VB, I'm wondering if someone could help me create a command button on a form (which is called "EFS&quot that opens another form (called SPRNotes) and automatically enters data into three fields:
1. ProjectID
2. Analyst
3. Current Date

Can anyone walk me through this? I've spent hours trying to get it right, with no luck. Thanks!

Kathy

 

[LarryDeLaruelle]

Kathy:

I will assume that the data for the first two fields will come from the calling form (EFS). If so, in the SPRNotes On_Open event try this code.

Me.ProjectID = Forms!EFS.ProjectID
Me.analyst = Forms!EFS.Analyst
Me.CurrentDate = Date()

This also assumes that the form EFS remains open after calling the form SPRNotes. If not, we will need to devise an alternative solution -- let me know.

This will take the values from ProjectID and Analyst on your EFS form and assign them to the equivalent fields on your SPRNotes form. Of course, change any field names to those used on the forms.

If you want the current date, just assign Date() to the date field on SPRNotes.

Hope this helps.
Larry De Laruelle
larry1de@yahoo.com

 

[msday]

Larry, worked beautifully! Thank you very much for your help.

Kathy