Solved

Auto fill an Access Form based off of a section from another view

Posted on 2012-03-20
1
277 Views
Last Modified: 2012-03-21
I have a form where I need to query a view (view has been added as an ODBC table) for a specific users full name.  Once the users full name is located, from the view, I want to grab the userid and populate it in another field that will update the table the form is designed form.  Can I do all of this on one form or will I have to have two forms?  Do my two tables (one table, one view) have to have a relationship established.

Hope this questions makes sense.
0
Comment
Question by:HMSImage
1 Comment
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
Comment Utility
One form should do.  If I understand your intent correctly, the tables needn't have a data relationship, as you are establishing a relationship by a manual process of searching the view.  However, if you do have a relationship, than the assignment can be automated so you don't need to do it manually.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now