Change ControlSource and Save Change

If u keep changing the controlsource, I would opt for no 2. Using it this way, u can make it flexible for different users to have different controlsource's.
e.g.

tblLocalCtrlSource
ID (PrimaryKey)
UserID  (if u dont keep one, u can use the api call to get the user's window logon)
FormName (only needed if u want to use this feature on multiple forms)
CtrlName (only needed if u want to use this feature on multiple controls on a form or u have multiple forms)
Value  (holds the last used controlsource)



On Form_Open, u can then use DLOOLUP to obtain the controlsource. If none found, then use default
On Form_Close, u can write to this table and save the controlsource

If u dont want to use a table, u can use the simple registry settings api calls

GetSetting
SaveSetting

Note, this is then dependant on the user's profile on that PC. It is not global like the temp table

Back to form design

once u close this, the caller then has to update the form

Public Function SaveLastCtrlSource()
    DoCmd.OpenForm "Form1", acDesign, , , acFormEdit, acHidden
    Forms!Form1!cboMonths.ControlSource = "NewControlSource"
    DoCmd.Close acForm, "Form1", acSaveYes
End Function


But then remember, if u do this, this makes changes global to all users unlike using a temp table

So look at the 3 options Ive given, if u have other ideas, let us know

This program is networked and may have 3 or more users at one time. So GetSettings SaveSetting will not work. And as each station has its on MDE copy, saving the form on one local computer would not work anyway, so my question is falled.

I am think of checking a related field that would indicate which ContorlSource to use.

Like

Private Sub Form_Current()

For ADn = 1 To 4
    If Me.Controls("AD" & ADn & "type").Value = 1 Then
        'Me.Controls("userRecurAD" & ADButChng & "txt").SetFocus
        Me.Controls("userRecurAD" & ADn & "txt").ControlSource = "userRecurAD" & ADn
    Else
        CS = "userRecurAD" & ADButChng & "Hrs"
        Me.Controls("userRecurAD" & ADn & "txt").ControlSource = "userRecurAD" & ADn & "Hrs"
    End If
Next
End Sub

ok, 3 or more users at a time

first of all its an MDE, so I do not think option 1 will work
secondly when the controlsource is modified, do u want this reflected to all users or just that one user?

Now reading your post, it seems you only have one of two rowsources to pick from

Do you share a backend database? or do each user have their own?

whatever the case may be, what u could do is create a config table
and a form to reflect this, give each recordsource a name, users can then play with this form, pick whichever one they want then load that up on form load - much like using the temp table