vaughan198
Registered User.
- Local time
- Today, 11:44
- Joined
- Nov 16, 2011
- Messages
- 40
Hi there.
Any help with this would be hugely appreciated.
I have an unbound form (for many reasons). I have a button which imports all the fileds on the form into a new record in a table (NewAccounts). This all works fine until I try to include a multi-select list box and then the whole thing falls apart.
I dont need to keep the data from the listbox in any particular format. I just need to display it as either a string or list in a report which will then get emailed out.
Currentl I am using the following code:
The listbox is called DesiredProd and the field in the table is called Desire.
Does anyone have any advice. Thanks so much.
Any help with this would be hugely appreciated.
I have an unbound form (for many reasons). I have a button which imports all the fileds on the form into a new record in a table (NewAccounts). This all works fine until I try to include a multi-select list box and then the whole thing falls apart.
I dont need to keep the data from the listbox in any particular format. I just need to display it as either a string or list in a report which will then get emailed out.
Currentl I am using the following code:
Code:
Sub SaveCommand_Click()
Dim db As DAO.Database
Dim rst As DAO.Recordset
'Dim varTextData As String
Set db = CurrentDb
Set rst = db.OpenRecordset("NewAccounts")
With rst
.AddNew
!DateSent = Me.Text51
!SAUser = Me.sausername
!USSalesPerson = Me.Sales
(some other fields)
Update
End With
rst.Close
some email code
End Sub
The listbox is called DesiredProd and the field in the table is called Desire.
Does anyone have any advice. Thanks so much.