[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

MS Acess 2010 form text box control data source question

Posted on 2011-03-15
2
Medium Priority
?
423 Views
Last Modified: 2012-05-11
Hi -

Is it possible to have a form which is using one table as it's data source but to have 1 text box on that form get data from a different source?

My form is connected to a table called ImportsTab

and my text box needs to be connected to a field called ExID in a table called ExportsTab

Thanks for any help

0
Comment
Question by:rinkydink
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points
ID: 35142902



explain, why you need the textbox to be connected to a field called ExID in a table called ExportsTab..

you can use dlookup() function to get the information from the other table.
if the two tables are related, you can use a query with joins in the two tables and use the query as the record source of the form..
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 35142909
Not exactly, but you can have the Text box 'lookup' a value from that table, using DLookup() .... for example ... set the Control Source of the text box to something like this:

=DLookup("[ExID]","ExportsTab")

mx
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question