[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

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

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
Elroy Taulton
Asked:
Elroy Taulton
1 Solution
 
dqmqCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now