Linking textbox to a option group

karinos

Registered User.
Local time
Today, 14:39
Joined
Jan 6, 2008
Messages
24
Hi,
I have this form called LOB Selection Tab. I want the user to go to this form and choose from the drop down box any selection he/she wants and then select one of the group options below like:
add to existing contract
Category unvialble and etc.....

So i want a macro or vba code that pulls the data based on the user's selection. The table that has this info is called "MainForm Tab1 Table"

Here is summary of what i am trying to say. For instance, the user selects "Surgical" from the drop down box and then selects "add to existing contract" from one of the option groups, so i want to see is the form to return only where there is only check mark has been placed in the add to existing contract field against Surgical. In other words, only filter a Surgical from the LOB field where there a check mark has been placed. I hope i am not confusing. I have already started to write some code but it does not seem that it is going well so far. Thanks in advance for your time and efforts.
 

Attachments

Karinos,

See if this is will work. For your OnClick event:
Code:
Private Sub Run_Click()

Select Case Frame34.Value
Case 1
    DoCmd.OpenQuery "add_to_existing_contract", acViewNormal, acEdit
End Select
End Sub
If the add_to_existing_contract query is only for that form then you can change the parameter to:
Code:
Like [Forms]![LOB Selection Tab]![QTextBox]

Hope this works.

Toby
 
I have used it before and for me, its easy to remember :)

Toby
 

Users who are viewing this thread

Back
Top Bottom