problem with Recordsource transfer from listbox to form

  • Thread starter Thread starter Lars Pedersen
  • Start date Start date
L

Lars Pedersen

Is this not possible?, I get the hourglass and nothing else happens.

Set frm = Forms(Me.OpenArgs)
frm.RecordSource = Me.lstShipInfo.RowSource



/Lars
 
Hi Lars,

I don't see why it shouldn't work, provided the tables/queries involved
are compatible. Certainly this has just worked in my test database:

Forms("AddrNew").RecordSource = _
Forms("frmTest").Controls("cboNotes").RowSource
 
I don't think they are compatible, the are based on the same table, but the
calling form shows 2 of them in subforms on relational basis (one to many).
And the lstShipInfo.RowSource (on a searchform) also contains several
criters that spans over all 3 tables. Anyway, I gave up this approch

/Lars
 
Back
Top