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.
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
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
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
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@stl-training.co.uk
Cheers
Stephen
