Really strugling with Access today so i could do with some help :)
I'm attempting to add items to a list box. The Sources are 2 text boxes which have been fed to from a querey. So first I tried...
Which brought up the error message
Run Time error '2185' - You cant referance a property or method for a control unless the control has the focus.
So i made sure that the querey was set up right by deselecting the backwards E, and i still get the same error.
I then changed the code to
and i get the error message '6014' - The RowSourceType must be set to 'value list' to use this method
Ive tried every way i know how... and still no luck
Any help would be appreciated