Multi-Line field into listbox? HELP

[Monty251]

Hi there,

I have a form where a user can select from a listbox (pulled from a database) and "Add product" - it then goes into a Textbox, each taking a new line when "Add product" button pressed. Then when they press "Add Customer" those details along with other entered details gets stored in my Customer Database..

The textbox store multi-line entries in the "ProductName" field heading in database.

Is there anyway i can use a List instead of the textbox? Adding individual entries to one certain customer? I have an EDIT facility aswell so would be easier to have a "Remove Product" button instead of manually backspacing a whole product entry from another textbox (containing all products, on new lines)

Alan

 

[mikejaytlabustro]

I think you have to make another table for the selected products and use CustomerID as foreign key. Just in case you need the data regarding of how many customers choose that particular product, its easy to pull out the records.

 

[Cronk]

I can understand a List box with the row source based on a table.

But I have no idea what you mean by and "Add product.

Do you have a command button which is to add the selected product in the list box as a new record?

 

[Monty251]

I can understand a List box with the row source based on a table.

But I have no idea what you mean by and "Add product.

Do you have a command button which is to add the selected product in the list box as a new record?

I have a button "add product" which adds the selected product in the list to a field in the customer table.

 

[Cronk]

What's the code/macro associated with your Add button?

Also what version of Access are you using?