Trying to load a listbox from a different form ?

[gazolba]

I have a form with a list box and a FIND button. When this button is pressed it leads the user thru a series of other forms to select records. I build an SQL and want to load it into the rowsource of the original form.
I'm using this code but it is not finding the form.

[Forms]![frmNewTicketSubform]![lstTickets].RowSourceType = "Table/Query"
[Forms]![frmNewTicketSubform]![lstTickets].RowSource = strSQL
[Forms]![frmNewTicketSubform]![lstTickets].Requery

I get no prompts when entering this code so dont know how to find out the correct reference. MS Access help was of no help (as usual)

 

[gazolba]

I should have mentioned the original form is a subform, so do I have to put:

{Forms]![mainform]![subform] ??

 

[PHV]

Try something like this:
Forms!frmMainForm!frmNewTicketSubform.Form!lstTickets.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884