My most complex form yet, could use a little direction, No hurry.

[koehlerc14]

So here is the deal,

I am attempting to make what is the most complex form i have made yet. It really is not much, but as an amatuer it is a little overwhelming. Here's a few critical background point.s

• I have 2 Master Databses - I will be linking in only 1 table from each - tblMaster
• Each record contains demographic data and about 40 "variable" fields which consist of a name for each variable, and its data
• Variable Field 20-29 - contains information about recent activity or communication with the record
• Variable field 37 contains "Informatio n regarding when we can contact the record"
• Variable Field 38 Contains "Call List list information"
• Variable Field 39 contains "Email communications for a particular project
• Variable field 40 contains Email Communications regarding updating their record

What I am attempting to do in this form is to choose a Query or Table to update, choose which variable fields to update, and finally update [Name] and [Data] fields.

I am using a bit of code and format which I used to simply export data in a specified query or table, but now want to do what an update query does in a form. Below is the code currenlty in place to export, I hope that it will work the same for me.

Private Sub UpdatefieldsButn_Click()
 
    Dim ID As Long
    Dim result As VbMsgBoxResult
 
    On Error Resume Next
'Queries Radial Select
    If (QueriesRB = True) Then
        If (QueriesCB.ListCount <= 0) Then
            result = MsgBox("No Queries defined.", vbExclamation, "Export for TSS Sample")
            Exit Sub
        Else
'Queries Action
            If Me.ProjectParticipationCheck = "True" Then
                If ([QueriesCB.Value].VarFieldName20 <= 0) Then
                    QueryDef.Updatable (
 
        End If
    Else
'Tables Radial Select
       If (TablesCB.ListCount <= 0) Then
            result = MsgBox("No Tables defined.", vbExclamation, "Export for TSS Sample")
            Exit Sub
        Else
'Tables Action
 
        End If
    End If
 
End Sub
 

Now I know what this is a very long post and asking a lot, but I'm not sure how to go about it. Whether using a bunch of if Statements or if a Case statement may work.

If anyone feels like being extremely helpful and taking a look at it, I'd greatly appreciate it. I'm a quick learner and happy to read up on the reference library that contains what I need and learn/do it myself, but need some guidance.

Thanks

[NeoPa]

I'm sorry, but I can't work out what you're even trying to do from your explanation. There are too many explanations that reference undefined items. As we don't know the undefined item - the explanation gives us no further understanding.
Don't feel that no-one wants to help, just that they can't with the info as supplied.