Me.RecordSource does not seem to work in Access 2007

[Stapes]

Hi

With the following code:

If global_orders_due_today = True Then
Me.TxtCurrentView = "DELIVERY DUE"
global_orders_due_today = False
Call disable_buttons
Me.RecordSource = "Orders for delivery today"
Me.DataEntry = False
Me.AllowAdditions = False
Else
If global_standing_orders = True Then
Me.TxtCurrentView = "STANDING ORDERS"
Call disable_buttons
Call disable_bottom_buttons
global_standing_orders = False
Me.RecordSource = "New standing orders "
Else
Me.DataEntry = False
Me.AllowAdditions = False
Me.RecordSource = "Current Orders"
Me.TxtCurrentView = "CURRENT ORDERS"
Call enable_buttons
Call enable_bottom_buttons
End If
End If

All the options display an empty screen in 2007, whereas in 2003 they
show data. Is this a bug?

Not holding my breath

Stapes

 

[Stapes]

Hi

With the following code:

If global_orders_due_today = True Then
                Me.TxtCurrentView = "DELIVERY DUE"
                global_orders_due_today = False
                Call disable_buttons
                Me.RecordSource = "Orders for delivery today"
                Me.DataEntry = False
                Me.AllowAdditions = False
            Else
                If global_standing_orders = True Then
                    Me.TxtCurrentView = "STANDING ORDERS"
                    Call disable_buttons
                    Call disable_bottom_buttons
                    global_standing_orders = False
                    Me.RecordSource = "New standing orders "
                Else
                    Me.DataEntry = False
                    Me.AllowAdditions = False
                    Me.RecordSource = "Current Orders"
                    Me.TxtCurrentView = "CURRENT ORDERS"
                    Call enable_buttons
                    Call enable_bottom_buttons
                End If
            End If

All the options display an empty screen in 2007, whereas in 2003 they
show data. Is this a bug?

Not holding my breath

Stapes

Hi

I am getting good at answering my own questions. I has a recordsource
in the main form and I was setting it in a subform. I don't remember
why I put a recordsource in the main form, but removing it made this
work.

Stapes