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

Auto file text box

P: 28
I want info from one form text box to auto fill another form text box when the second box gets the focus.
I tried an Expression did not work and I tried this code
"Me!txtIncidentNumber = Me1Incident.txtIncidentNumber
May 26 '07 #1
Share this Question
Share on Google+
4 Replies

P: 11
Have you tried using DLookup?
May 26 '07 #2

P: 28
Have you tried using DLookup?
No but will try this and see what hajppens
May 26 '07 #3

NeoPa
Expert Mod 15k+
P: 31,770
I'm not sure exactly, but see if this (Example Filtering on a Form.) will help you.
May 27 '07 #4

jamjar
P: 50
I want info from one form text box to auto fill another form text box when the second box gets the focus.
I tried an Expression did not work and I tried this code
"Me!txtIncidentNumber = Me1Incident.txtIncidentNumber
I assume you mean
"Me!txtIncidentNumber = Me!Incident.txtIncidentNumber".
Is "Me!Incident .txtIncidentNumber" meant to refer to the textbox that has been filled out? If so, I think you will need to change it to
Expand|Select|Wrap|Line Numbers
  1. Forms("Incident")!txtIncidentNumber
as "Me" can only refer to the form from which you are running the code. Both forms would have to be open.
The other option would be if the textboxes txtIncidentNumber on both forms are bound to the same field, you could make sure you save the record on the first form and use Me.Requery on the second form when it is activated to refresh the values.

James
May 28 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.