PatDunlavey
asked on
Dynamically calculated field in Form - newbie question
I'm very new at databases and Access, so please be kind...
I have two tables, A and B (in a one to many relationship). I'm trying to create a form for entering data into table A, such that as fields in the record are filled in, an unbound text field will dynamically assemble and display information taken from table B.
If I just enter an expression into the text field's control source property, it doesn't seem to be able to work outside of table A.
Do I need to create a query to mediate between the form and table A and B?, and to create the text for the display field? And if so, will/can the text display field update dynamically as the data entry fields are filled in?
Do I need to learn VBA to do what I am looking for?
Any help would be very much appreciated!
I have two tables, A and B (in a one to many relationship). I'm trying to create a form for entering data into table A, such that as fields in the record are filled in, an unbound text field will dynamically assemble and display information taken from table B.
If I just enter an expression into the text field's control source property, it doesn't seem to be able to work outside of table A.
Do I need to create a query to mediate between the form and table A and B?, and to create the text for the display field? And if so, will/can the text display field update dynamically as the data entry fields are filled in?
Do I need to learn VBA to do what I am looking for?
Any help would be very much appreciated!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
for PatDunlavey
No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- Answered by: JDettman (100) nico5038 (100)
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- Answered by: JDettman (100) nico5038 (100)
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
Force accepted
** Mindphaser - Community Support Moderator **
Nico, there will be a separate question with points for your help.
** Mindphaser - Community Support Moderator **
Nico, there will be a separate question with points for your help.
Normally a one to many relationship is used by adding a subform on a mainform.
The mainform is based on the main table and the subform (based on the dependent table) is linked by it's "mainkey-part" to the mainform.
Just using the access wizard, that starts automatically when you place a subform from the toolbox at the left, will guide you through all steps.
Thus only related rows will be displayed in the subform.
Basing one form on a "JOIN" query has the danger of getting a "read-only" situation, not enabling changes to the fields.
What do you want to display in that text field and what do you want to display when you have multiple "B" rows to one "A" row?
Nic;o)