Passing Dynamic Values between forms

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

Guest

i keep getting an error 2491 report or form is not bound to a table or query.

i have a list box set up based on a query. i have the list to be able to
double click, then pass the value to another form. on the new form, i have
another list box there bound to a query that is dependant on the passed
value. so what am i missing?
 
How do tou pass the value from one form to another?
If you pass it using the where condition, this is why you get that error.
Pass it with the openArgs, and on the load of the second form assign the
filter to the ListBox
On the OnLoad event of the second form you can assign SQL to the RowSource
of the list box

Me.ListBoxName.RowSource = "Select * From TableName Where Field1 = " &
me.openArsg
 
Back
Top