form behavior

  • Thread starter Thread starter krep
  • Start date Start date
K

krep

hello all,

another question from a newb...

i have a form with a listbox that's populated by a view (.adp a2k).
listbox (L1) has an onclick event that's supposed to create a
recordsource and populate a subform (sub1). From L1's onclick event,
the statement Me!sub1.Form.RecordSource=sqlstr produces the error "The
expression you entered refers to an object that is closed or doesn't
exist." Can't figure out how to address that subform from the listbox
onclick event. Any help is greatly appreciated!

- krep
 
Me.sub1.Form.RecordSource=sqlstr

"sub1" must be the Name property of the subform control which may be
different from the subform's name when you view it in the database container
window.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box, List Box & a Sub Form 4
Control a form with a subform? 5
change to SQL - where and what? 1
Subform control OnClick firing 1
Filter records in a subform based on list box selection 5
Multiple Muliselect Listbox form update 1
Programmatically Close a form 1
Filter Parent Form by Subform's Listbox Selection 2

Back
Top