Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-17-2019, 11:51 AM   #1
jahanzaibrana47
Newly Registered User
 
Join Date: May 2019
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
jahanzaibrana47 is on a distinguished road
How can we populate text boxes/fields (in a Form) by linking it to data in a query?

Hi Everyone,

Jay here, and I have been working with my company's small customer client database. I have multiple data entry forms which I use as the frontend to enter data into my tables. However, there is one form, for which, I want to enter data/populate it by data from another table.

[I know its confusing, explained it further below]

The Master Contract (Form) contains policies which are predefined and stored in a separate table. It was suggested to me that the form should have a mechanism/function that:

IF a particular service is selected (in the master contract form) by clicking on the drop-down menu

THEN the fields for that particular service should be populated BY the values in the policy table.

Example:
Master_Contract_Form-
Fields in the Form: Customer_Name, Service Type, Policy1, Policy2, Policy3

Policy_Table:
Columns/Fields in the Table: Service Type, Policy1, Policy2, Policy3

So, IF I enter a new customer_name and a service_type, then I want to get the Master_Contract_Form to get data from Policy_Table regarding policies related to that particular service_type.

Is there a way to do it? Or the question is still unclear?

I would appreciate any help.

Best,
Jay

jahanzaibrana47 is offline   Reply With Quote
Old 05-17-2019, 12:03 PM   #2
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,653
Thanks: 0
Thanked 405 Times in 402 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: How can we populate text boxes/fields (in a Form) by linking it to data in a quer

Why duplicate the 3 policy fields into MasterContract table? Options:

1. multi-column combobox to select Service Type, textboxes reference columns of combobox to display each policy data

2. build a query that links records, bind textboxes to policy fields, set Locked Yes and TabStop No

Multiple similar name fields indicates non-normalized data structure.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
jahanzaibrana47 (05-20-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Box search on ID and populate other text boxes in same form srinutsrao Forms 2 11-13-2013 07:55 PM
Linking master form ID to automatically populate ID fields in child forms Angharad123 Forms 8 02-20-2013 01:34 AM
Trying to populate form text boxes from a query ritco Modules & VBA 3 09-06-2012 11:29 AM
Populate text boxes from a combo box query _JSincliar Modules & VBA 4 09-08-2010 12:45 PM
populate text boxes from a query result jammyp Forms 6 02-20-2006 12:57 AM




All times are GMT -8. The time now is 05:52 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World