98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Combo Boxes
Combo Boxes
Resolved · Urgent Priority · Version 2003
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.
Wed 21 Apr 2010, 11:11Trainer Stephen said...
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
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.
Wed 21 Apr 2010, 11:25Trainer Stephen said...
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
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
Wed 21 Apr 2010, 11:34Trainer Stephen said...
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
Wed 21 Apr 2010, 11:43Delegate Suzanne said...
RE: Combo Boxes
Hi Stephen,
That has not worked!!!
Wed 21 Apr 2010, 11:50Trainer Stephen said...
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@stl-training.co.uk
Cheers
Stephen
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. |
Access tip:Action queriesUnlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read. |
