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

Update a form field

P: n/a
Hello,

I have a form that has a field that needs to be updated from data on
another table. The field that needs updating is named RFF #. The
table that contains the data is in tblConsolidated_ISP's and the name
of the field in this table is New ISP #. So basically, I have a field
on a form that needs to be updated with data from
tblConsolidated_ISP's field name New ISP No.

I know that to combine the data I can run a query but in this case it
would cause a problem. I have tried to use dlookup and it works fine
but when using dlookup the field that is populated is really not
populated and can not run queries off of the data. I also tried to
change the source of RFF # to [tblConsolidated_ISP]![New ISP No] and
it gave me a Name? in the field.

Does anyone have any ideas on how to my field on the form equal data
from tblConsolidateISP?

Thank you
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Tony wrote:
Hello,

I have a form that has a field that needs to be updated from data on
another table. The field that needs updating is named RFF #. The
table that contains the data is in tblConsolidated_ISP's and the name
of the field in this table is New ISP #. So basically, I have a field
on a form that needs to be updated with data from
tblConsolidated_ISP's field name New ISP No.

I know that to combine the data I can run a query but in this case it
would cause a problem. I have tried to use dlookup and it works fine
but when using dlookup the field that is populated is really not
populated and can not run queries off of the data. I also tried to
change the source of RFF # to [tblConsolidated_ISP]![New ISP No] and
it gave me a Name? in the field.
????

Where do you use Dlookup? As the control source? If so, then it is a
calculated field. In your BeforeUpdate event for the form you could enter

Me.TableFieldName = Me.DlookupFormFieldName

But I guess you want to add it to the table. At some point you can get
the rff#. In the AfterUpdate event of the control that allows you to get
the number you could do something like
Me.FormRFFFieldName = Dlookup(....)
or put in the Before update event of the form.



Does anyone have any ideas on how to my field on the form equal data
from tblConsolidateISP?

Thank you


Nov 12 '05 #2

P: n/a
Thanks for the response. I did have the dlookup in the control source.
I do need to add it to the table. I dont think that dlookup does add it
(at least the way I tried)but I will try what you said. In the
Me.FormRFFFieldName = Dlookup(....) Are the dots suppose to be there?

thank you


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
Troy wrote:
Thanks for the response. I did have the dlookup in the control source.
I do need to add it to the table. I dont think that dlookup does add it
(at least the way I tried)but I will try what you said. In the
Me.FormRFFFieldName = Dlookup(....) Are the dots suppose to be there?

No. Elipses usually mean MORE. Continue on. Fill in the blank....at least
I assume that when I see it in computer manuals.

If I made the DLookup the control source, what is the control? Certainly
not the field in the table. Ex: I could have a field in a table called
LastName. I could drag that field onto the form. I could then Name it
HowdyDoody. Throughout the form I would reference it as HowdyDoody but when
all is said and done, I am working with and updating LastName. Ex. Your
name may be Troy, but your nickname is BigT. I may say "How's it going
BigT"...which is the Name in the property sheet under Other but I am really
addressing Troy, the control source.in the Data tab.

Dragging a text box, calling it a name in a table field, but giving it a
control source of Dlookup has nothing to do with the table.


thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.