mud2
03-08-2006, 10:03 PM
Form_Table1 is based on Table1. I want to open the form and have it display only chosen records from the table.
DoCmd.OpenForm "Form_Table1", , (Condition)
The condition is WHERE F_Name = "Owen"
F_Name is the name of a field in Table1. Access "Help" says don't use the "Where".
DoCmd.OpenForm "Form_Table1",,F_Name = "Owen"
Does not work;
DoCmd.OpenForm "Form_Table1", , "Select * FROM Table1 Where F_Name = 'Owen'" does not work either
???
DoCmd.OpenForm "Form_Table1", , (Condition)
The condition is WHERE F_Name = "Owen"
F_Name is the name of a field in Table1. Access "Help" says don't use the "Where".
DoCmd.OpenForm "Form_Table1",,F_Name = "Owen"
Does not work;
DoCmd.OpenForm "Form_Table1", , "Select * FROM Table1 Where F_Name = 'Owen'" does not work either
???