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

Combo Box, Subform, Text Box - Relationships/Filter

P: 19
What I am trying to do is select an item from the combo box and have it displayed in the subform. Then once you scroll though the subform and find the field you like, click on it and it will automatically be transferred to a text box.

I have created a 3-step image demonstrating how it should look.

Also I have the information behind the subform linked together as a foreign key in a relationship.

Click Here

Please help me see what I am doing wrong, thank you.
Aug 2 '07 #1
Share this Question
Share on Google+
1 Reply


100+
P: 167
Hi W.

You could write in subform control's on double-click event a code like this:

Dim TransferValue As variant
TransferValue=Me!SubformControlName

Forms!MainForm.SetFocus

If Forms!MainFormTOC1="" Then Forms!MainFormTOC1=TransferValue
Else
If Forms!MainFormTOC2="" Then Forms!MainFormTOC2=TransferValue
Else
Forms!MainFormTOC3=TransferValue
End If

Hope this helps...
H.
Dec 11 '07 #2

Post your reply

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