472,129 Members | 1,579 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,129 software developers and data experts.

Combo Box, Subform, Text Box - Relationships/Filter

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
1 2336
167 100+
Hi W.

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

Dim TransferValue As variant


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

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

Post your reply

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

Similar topics

3 posts views Thread by Phil | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.