Subforms

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

I try to place a find button to search on subform in the
main form and it won't search -- I keep getting an error
that essentially I can't search right now.
As well, my subform is titled frmPhone_Entry and when I
try to code I think I need to have it in brackets -- not
sure

as well, my sub form is titled frmsub entry

Do I need to do something in oced when I am referring to
them because of the space or the _
Thanks a million!
 
This line:

Screen.PreviousControl.SetFocus

seems to make no sense for what you want to do. It should be changed to
this:

Me.SubformName.SetFocus

where SubformName is the name of the subform control (the one that holds the
subform) on the main form; this name may or may not be the same as the name
of the form that is the subform. You can get this name by opening the form
in design view, clicking on the subform control, opening the Properties
window (icon on toolbar), clicking on Other tab, and reading the name of the
control in the Name box.
 
Back
Top