List Box Problem

  • Thread starter Thread starter John Daily
  • Start date Start date
J

John Daily

I have a multi-column list box that is unbound and gets
info from a query. I have the user choose a number in a
combo box and that determines what appears in the list
box. The combo box is unbound and the form is unbound.
My problem is that when the user clicks on one (and only
one) record in the list box, I want to pass an acct number
to a subform. The acct number is the bound column. How
do I do this?

Please help, I am running out of time and have finished
reading two books.

TIA,

John
 
Hi,
Do you mean you want a control on the subform (on the
same form as your listbox?) to display the value?
Something like this in the click event of your listbox:

Me.NameOfYourSubformControl.Form!nameOfControl = Me.yourListbox

If the subform is on a different form:
Forms!nameOfForm!NameOfYourSubformControl.Form!nameOfControl = Me.yourListbox
 
Thanks Dan for your reply.
The list box is on the main form and when the user clicks
on an account within the listbox then that account
information that is in the listbox is passed to the
subform. Ultimately what I want is when the information
is displayed in the subform I want the user to be able to
use a check box that shows whether or not they worked the
account.

Thanks for your help!

John
 
Back
Top