|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 7th, 2004, 08:15 PM
|
|||
|
|||
How do I set up a field in Access 2000 to accept multiple combo b.
I have a field "remarks" that I would like autofilled with multiple
selections from combo boxes I have set up. ie After I select on choice... I can then select another and have it fill in after... to form a sentence. Is this possible? Thank You! 
|
|
#2
September 7th, 2004, 08:55 PM
|
|||
|
|||
|
You could use the AfterUpdate event of each combo box to run code that
concatenates its value into the textbox: Private Sub ComboBoxName_AfterUpdate() Me.TextBoxName.Value = (Me.TextBoxName.Value + " ") & Me.ComboBoxName.Value End Sub -- Ken Snell MS ACCESS MVP "CMorgan" wrote in message ... I have a field "remarks" that I would like autofilled with multiple selections from combo boxes I have set up. ie After I select on choice... I can then select another and have it fill in after... to form a sentence. Is this possible? Thank You!
|
|
#3
September 8th, 2004, 07:13 PM
|
|||
|
|||
|
Thank You Ken! Your a life saver
Christy "Ken Snell [MVP]" wrote: You could use the AfterUpdate event of each combo box to run code that concatenates its value into the textbox: Private Sub ComboBoxName_AfterUpdate() Me.TextBoxName.Value = (Me.TextBoxName.Value + " ") & Me.ComboBoxName.Value End Sub -- Ken Snell MS ACCESS MVP "CMorgan" wrote in message ... I have a field "remarks" that I would like autofilled with multiple selections from combo boxes I have set up. ie After I select on choice... I can then select another and have it fill in after... to form a sentence. Is this possible? Thank You!
|
|
#4
September 8th, 2004, 07:48 PM
|
|||
|
|||
|
You're welcome.
-- Ken Snell MS ACCESS MVP "CMorgan" wrote in message ... Thank You Ken! Your a life saver Christy "Ken Snell [MVP]" wrote: You could use the AfterUpdate event of each combo box to run code that concatenates its value into the textbox: Private Sub ComboBoxName_AfterUpdate() Me.TextBoxName.Value = (Me.TextBoxName.Value + " ") & Me.ComboBoxName.Value End Sub -- Ken Snell MS ACCESS MVP "CMorgan" wrote in message ... I have a field "remarks" that I would like autofilled with multiple selections from combo boxes I have set up. ie After I select on choice... I can then select another and have it fill in after... to form a sentence. Is this possible? Thank You!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
| Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
| Can I return multiple tables using Access 2000? | [email protected] | Running & Setting Up Queries | 4 | August 4th, 2004 05:02 PM |
| Can I return multiple tables using Access 2000? | [email protected] | General Discussion | 2 | August 4th, 2004 04:55 AM |
| SQL Server 2000 Stored Procedures to MS Access 2000 Queries | CS | General Discussion | 4 | July 15th, 2004 03:27 AM |
Linear Mode
