subform problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a subform on my main form. the subform has an underlying query
attached to it. i made a button on the main form which displays data on the
subform. the field that is required is the name only. the subform's source
object depends on the button i click. the query is this: "select * from table
where name like [Enter name:];" the problem is this: there are 2 instances of
the question "Enter name:" appearing, how do i eliminate this, the other
instance of it i mean. thanks!
 
If you added a subform with the wizard (ensure the wizard button is
selected), it will create the filter for you that joins the main form and the
subform (or more accurately you specify the join field in the wizard) , ie
you filtered subform data will automatically appear without any button
presses. Try adding the subform with the wizard and when the wizard asks for
which fields join the main form to the subform, select the option that is
presented to you. ie: select it from the list, or alternatively you could
select your own but this is normally not required.
 
Back
Top