By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

Passing values between forms

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.