The following stement will not compile, I get a message about variable
not defined on the tblEquipmentSchedule after the AND. I am fairly new at
using SQL in code so I am sure it is something silly.
Form_frmEquipmentSchedule.RecordSource = "SELECT
tblEquipmentSchedule.EquipmentID, " & _
"tblEquipmentSchedule.PoolID, tblEquipmentSchedule.FriendlyName, " & _
"tblEquipmentSchedule.EquipmentType,
tblEquipmentSchedule.Manufacturer,
" & _
"tblEquipmentSchedule.MotorSize, tblEquipmentSchedule.DesignAmpDraw, "
&
"tblEquipmentSchedule.SerialNumber, tblEquipmentSchedule.Model, " & _
"tblEquipmentSchedule.PhotoPath, tblEquipmentSchedule.SupplierID, " &_
"tblEquipmentSchedule.Warranty, tblEquipmentSchedule.Notes " & _
"FROM tblEquipmentSchedule " & _
"WHERE tblEquipmentSchedule.EquipmentID Like '" &
Forms!frmEquipmentFind!txtEquipID & " % " And tblEquipmentSchedule.PoolID
=" & Forms!frmPoolData!ID & ' ;"

Rather than throwing your entire recordsource into a coded SQL statement, try DoCmd.OpenForm "FormName",,,"WHERE CLAUSE". If the form's already open this has the effect of refreshing it with the filter on.

[This message has been edited by David R (edited 05-01-2002).]