strSQL:

(([Sq_Ft] = 36317) AND ([County] In ('Canadian'))

Does anyone see what the problem is with this when used in:

DoCmd.OpenForm FormName:=strForm, View:=acNormal, WhereCondition:=strSQL

I have a program written using Office XP Developers package that I wrote
about 4 years ago. I've been running the program on 2 different machines now
since then without a single problem. Due to one machine being taken out by
lightning I was forced to replace it with a new system from Dell that I
could find XP still available for as a choice of OS.

At any rate I got Office XP Developer to install with a bit of effort but
now have it up and working. My Access program is a stand a lone but very
complicated. At any rate the program is now dropping data between forms and
sub forms on the new machine while still working fine on the old system.

When I wrote this years ago I used a couple of lines of code that would
show me with a popup screen what was happening with things like SQL formats
as well as variable contents. For the live of me I can't remember now how I
did it. Any help on this would be greatly appreacieted as I really need to
solve the problem on the new machine.

Oh and one other not both the old machines are running different versions of
XP. The one being replaces ran XP Home, the other old machine is running XP
Media Center with both having 2G ram. The new machine also a Dell I got with
4G ram installed but running XP Pro. All 3 machines had all patches,
upgrades etc installed current.

Hi All,
I would like to be able to change the record source of a subform when I
click on a tab thats on a main form but I keep getting a error message.
main form is called "CardFrm"
Tab Control is called "AllTabs"
Page is called "CustomersPage"
I want the recordsource to be a query called "CardCustomerQry"

when I click on the tab I want the record source of the subform to change to
a difrent query is this posible?
Steve
From a land down under

I have two forms, the first is a continous form containing a list of
addresses. On another tab I have the 2nd continous form which filters for any
occurance of a matching record in any of two fields that relate to a field on
the 2st form, using this filter criteria:

Run_waypoint_ID_From=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID Or
Run_waypoint_ID_To=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID

1st form: Frm_Run_Waypoints
2nd form: Frm_Road_Restrictions

The problem is that the 2nd form will only show records based on one address
on the 1st form. I want it to show ANY matching records that appear on the
1st form. How can I do this?

For example, how can I get it to show ‘Quality Street and ‘South Street’