Hi and thanks for your help
I have a form "Lots"
in the Lots Form I have a
Private sub L-SitingArea_AfterUpdate()
If Me.L_SitingArea = "CESSNOCK_DCP" Then ##NEED HELP HERE## i want to call a module called read_CESSNOCK_DCP_DUPLEX
If Me.L_SitingArea = "NSW_GREENFIELD_CDC" Then Call read_NSW_GREENFIELD_CDC
If Me.L_SitingArea = "HUNTLEE_DCP" Then Call read_HUNTLEE_DCP
If Me.L_SitingArea = "LAKEMAC_DCP" Then Call read_LAKEMAC_DCP
If Me.L_SitingArea = "MAITLAND_DCP" Then Call read_MAITLAND_DCP
If Me.L_SitingArea = "SINGLETON_DCP" Then Call read_SINGLETON_DCP
If Me.L_SitingArea = "CENTRAL_COAST_DCP" Then Call read_CENTRAL_COAST_DCP
If Me.L_SitingArea = "PORTSTEPHENS_DCP" Then Call read_PORTSTEPHENS_DCP
If Me.L_SitingArea = "NEWCASTLE_DCP" Then Call read_NEWCASTLE_DCP
End Sub
However all the read_SUBS are on the same page, I want to create modules for each read_Sub, (easier to manage for updating or deleting) but I don't know how to call the module
With thanks
Craig