Re: Display Multiple Data Fields based on drop down selection

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Peter.

"Peter" wrote:
I have a subform that I want to use to track some resource-specific
information relative to a project. I have a TeamMember table that
have foreign-key fields that link to the Resource table (containing
much of the needed data) and the Project Table.
I've seen this done with a Classroom Database I downloaded from the
Microsoft Templates site but cannot get it to work for my database
- ugh. Basically I want the user to be able to select the Resource
Name from the Subform drop down field and have the DeskPhone,
MobilePhone, SkypeName, Location, and Company fields automatically
populate in the subform with the data stored on the resource table.
I also want to allow the user to update the data within that subform
and have that updated data change reflect in the resource table;
I.E.: if the user's DeskPhone needs to be changed, the user can
change that in this subform without having to go to the Resource
table or another Resource contact form.
So how do I do this?

Base your subform on a query that joins the TeamMember table witht
the Resource table. It should contain the ProjektID, ResourceID,
other relevant data from the TeamMember table, and the fields from
the Resource table: DeskPhone, MobilePhone, SkypeName, Location and
Company.
If you enter a ResourceID (for example by selecting a Resource Name
in a combo box), Access will immediately show the data from the
Resource table and allow for editing.

--
Regards,
Wolfgang


.

Relevant Pages

  • Re: deleting records
    ... If your subform is a single form, all the fields you see in the ... Your Resource For Help With Access, Excel And Word Applications ...
    (comp.databases.ms-access)
  • Re: Display Multiple Data Fields based on drop down selection
    ... Would I create the subform by using the query (which by the way you were ... How do I get the data from the query into the TeamMember table? ... have foreign-key fields that link to the Resource table (containing ...
    (microsoft.public.access.forms)
  • Re: Display Multiple Data Fields based on drop down selection
    ... "Peter" wrote: ... Would I create the subform by using the query (which by the way you were ... How do I get the data from the query into the TeamMember table? ... have foreign-key fields that link to the Resource table (containing ...
    (microsoft.public.access.forms)
  • Re: Subform email
    ... This works great for the email on the first record in the subform. ... make it populate the email of the resource in all the records on the subform? ... items on subform are Tasks assigned to a Resource with a DueDate. ...
    (microsoft.public.access.formscoding)
  • Display Multiple Data Fields based on drop down selection
    ... I've seen this done with a Classroom Database I downloaded from the ... Basically I want the user to be able to select the Resource Name from the ... Subform drop down field and have the DeskPhone, MobilePhone, SkypeName, ... if the user's DeskPhone needs to be changed, ...
    (microsoft.public.access.forms)