By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Combo Box

P: 91
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
Apr 4 '12 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,409
That can never make sense, but what might is hard to say without an idea of what the subform is there for.
Apr 5 '12 #2

P: 91
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.
Apr 5 '12 #3

NeoPa
Expert Mod 15k+
P: 31,409
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.
Apr 5 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.