If the first form is open, you can get any value from the first form's current
record in the second form with:
Me!MyFieldName = Forms!NameOfFir stForm!NameOfFi eldInFirstForm
You can pass any string value to the second form from the first form when you
open the second form from the first form with:
DoCmd.OpenForm "NameOfSecondFo rm",,,,,,"Strin g To Pass"
In the second form you retrieve this string value with:
Me!MyFieldName = Me.OpenArgs
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com www.pcdatasheet.com
"Al Jans" <al******@yahoo .com> wrote in message
news:7b******** *************** ***@posting.goo gle.com...
Hi, I'm having a problem passing a value from a field on one form to
another field on another form. The value is being passed between
forms, however it's not being displayed and i've got no idea why.
Any suggestions or help would be appreciated.
Thanks
Alex Jans