Select a Customer from ListBox????

[Malik via AccessMonster.com]

Hi
I Have a form "FrmSales" with several fields as customer Id and Customer Name.


After CustomerId And CustomerName I have a small button by pressing it a new
farm appears with a list box having all my customers Id's and names....

I want that by double clicking on a customer name in list box, It fill up the
CustomerId and Name feild in the FrmSales with selected Customer from Listbox.


Thanks.

 

[Arvin Meyer [MVP]]

Aircode:

Sub ListBoxName_DblClick()
Me.CustomerIDControlName = Me.ListBoxName
Me.CustomerName = Me.ListBoxName.Column(1)
End Sub

A list box can have many columns, the first is usually the ID field and it
is Column(0). Being the bound column, it isn't necessary to identify the
column index. Customer name can be hidden (ColumnWidth set to 0) or visible,
and the second column is Column(1)

While the CustomerID is require on a sales form, the Name isn't stored in
the table, so do not bind the CustomerName to the underlying field. In the
form's current event, you can display the customer name, by binding it to an
underlying query.

 

[malik via AccessMonster.com]

Aircode:

Sub ListBoxName_DblClick()
Me.CustomerIDControlName = Me.ListBoxName
Me.CustomerName = Me.ListBoxName.Column(1)
End Sub

Thanks Buddy

But My List Box is exist in another form named "FrmListCustomers", Not in
FrmSales.


Now tell me what to do ???

 

[Douglas J. Steele]

Thanks Buddy

But My List Box is exist in another form named "FrmListCustomers", Not in
FrmSales.

Me.CustomerName = Forms!FrmListCustomers!ListBoxName.Column(1)

 

[malik via AccessMonster.com]

I think It Will Be As:

Sub ListBoxName_DblClick()
[Forms]![FrmSales].[TxtCustomerId] = Me.ListBoxName


End Sub

I think Its Correct..

Thanks Bro.

Some Time I think That I could not make a single table If i did not join this
Forum..

People on this forum are very HelpFul..

Thanks Again