var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Filling Form fields
I have a form with two combo boxes and I want to fill each combo depending on the value of the other:
Example for one of the Combos:
SELECT [CourseHistoryBeginDate] FROM CourseHistory WHERE ((([CourseHistory.CourseHistoryCourseID])=[Forms]![CourseContacts]!CourseContactsCourseID));
I've been trying different approaches with no sucessful results.
Please provide some input on how to solve this.
Beginner's questions :-)
Make sure you are referencing the right column in you're combo field. Also you may need to refresh your form before selecting from the second combo.
You can requery the secondcombo each time when the first combo is updated,
You can use the AfterUpdate procedure from the first combo.
forms!yourform!secondcomb.rowsource = "SELECT....."
Last edited by Lierduh; 06-03-03 at 19:12.