Forum home » Delegate support and help forum » Microsoft Access Training and help » Combo Boxes
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Combo Boxes
Resolved · Urgent Priority · Version 2003
Reply Wed 21 Apr 2010, 09:32Delegate Suzanne said...
Suzanne has attended:
Access Intermediate course
Combo Boxes
I have created my combo box and I need to add a new Row source, it is showing on the table view, but when I am in form view the new entry is not showing when I click on the drop down arrow.
Sorry I have put this as urgent but tomorrow is my last day and I need to hand this over.
For upcoming training course dates see: Pricing & availability
RE: Combo Boxes
Hi Suzanne
Thanks for your question
Could you clarify something for me. Does your combo box take its data from a table or query, or is it based on a value list?
Thanks
Stephen
Reply Wed 21 Apr 2010, 11:21Delegate Suzanne said...
RE: Combo Boxes
My Combo box takes it data from a table. Not sure what a value list is.
RE: Combo Boxes
Hi Suzanne
That's great. Two more points of clarification.
1. Am I correct in thinking that you are adding a new record to the table which is the row source for the combo, but the new entry is not appearing in the combo box on the form?
2. When you built your combo, did you do it in the design view of the form, or in the table that holds the data?
Thanks
Stephen
Reply Wed 21 Apr 2010, 11:28Delegate Suzanne said...
RE: Combo Boxes
Hi Stephen,
1. Yes that is correct
2. I done it in Design View
RE: Combo Boxes
Hi Suzanne
OK, the first thing to check is that the form has properly refreshed. If it was open when you made the changes to the table, then the new data might not appear until you close the form and reopen it.
Close the form and reopen it.
If this doesn't solve the problem, let me know
Cheers
Stephen
Reply Wed 21 Apr 2010, 11:43Delegate Suzanne said...
RE: Combo Boxes
Hi Stephen,
That has not worked!!!
RE: Combo Boxes
Hi Suzanne
This is rather hard to solve without seeing the database. Could you zip it up and email it to me. If so please also tell me the name of the form that is causing you problems
My email address is sw
Cheers
Stephen
|