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!NameOfFirstForm!NameOfFieldInFirstForm
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 "NameOfSecondForm",,,,,,"String 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******@pcdatasheet.com www.pcdatasheet.com
"Al Jans" <al******@yahoo.com> wrote in message
news:7b**************************@posting.google.c om...
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