Seth, I dont know quite what to say apart from you are amazing!!
Thanks so much for all the help it really is appreciated!!
Just gota try and make the reports now so il probably be back tomorrow with more problems!
Thanks again
Brent
thanks for the reply seth.
I have got the field name in the control source property of the list box but when selections are made it is not storing anything in that field in the table.
The list boxes are set for multi select - simple mode so the user could select 3 options for instance and they...
Does anyone have any ideas?
All I need it to do is store the options selected in the specified field in the table. So if the user selects Flamable and explosive from the list they are added to the field specified in the control source property of the list box.
Just cant seem to get it to store...
Hi,
I have a form with various list boxes that display options based on a query. When options are selected the text relating to them is populated in a seperate text box at the side.
The problem im having is when I select options from the list box I want it to store the selected options in the...
Im using the following vba Code to try and populate a text box with multiple line based on selections from a list box.
Private Sub Precautions_AfterUpdate()
Dim Criteria As String
Dim ctl As Control
Dim Itm As Variant
Set ctl = Me.Precautions
For Each Itm In ctl.ItemsSelected...
sort of but says theres a combo box with a b c d in and theres text associated with it so in the table ive got a field called heading and field called sub_text so each heading has subtext that relates to it.
so when a user selects a from the combo the associated text pops up in a text box next...
Hi Im new to the forum and new to the world of using VB in Access so any help with this would be appreciated.
Ive created a database that Is going to create data sheets. I have two main tables ; Major_Cat and Sub_Cat that are linked in a one to many relationship.
Ive created a form that has...