Combo Box

[sg2808]

Hi,

One more query on Combo Box.

I have the following tables and fields:

Table 1 - [RuleDetail], the fields are:
RuleDetailID
Rule_ref_1
Rule_ref_2
Description
Procedure
Initial_assessment
Active/Inactive
Notes

Table 2 (Junction Table) - [RuleDetail_Owners], the fields are:
RuleDetail_OwnerID
RuleDetailID
OwnerID

Table3 - [Owner], the fields are:
OwnerID
Name
Role

Using form wizard, I have selected all the fields from the above tables and based the form on [RuleDetail].

The subform created, apart from other fields, has the two fields - [Name] and [Role] whcih appears as Text box.

I have changed the above two text box as Combo box and used a query in RowSource in property and selected [Name] from the table [Owner]. Similary, I did the same for the [Role].

Curently, I have to slect the Name and the Role one by one.

What I want is that if a user selects the dropdown say from the [Name], the [Role] field automatically fills up.

I am wondering if this is possible and how to do it?

Any help is very much appreciated.

SG

[NeoPa]

That can never make sense, but what might is hard to say without an idea of what the subform is there for.

[sg2808]

The subform is to show the [Name] and [Role] of the Owner of the Rules.
The Rules are in table[RuleDetail] and name and owner is in table [Owner]. Hope this makes some sense.

[NeoPa]

sg2808:
Hope this makes some sense.

It throws very little (if any) light on the matter, I'm afraid. Your description of the form structure has no discernable connection to the relationship between the tables.

If [RuleDetail] and [Owner] share a many-to-many (M:N) relationship then you need to explain how the subform is configured, with what data, and how that data is filtered. Just saying that it contains records from [Owner] leaves you without a question that makes sense.