Hi All,
I have a form with a number of fields into which i want to be able to pick from a list of existing records and also be able to enter data to be saved as new.
The Form is basically for inputting Date, Tutors Names, Work Day Names, Course Name, Class Name, Course Level, Hours Worked, Total Hours.
When I try to set the LimitToList in the combo box properties I get an error saying;
Access can'nt set the LimitToList Propery to right now.
The first visible column, which is determined by the ColumnWidths Propery, is'nt equal to the Bound Column. Adjust the ColumnWidths Propery first, and then set the LimitToList Property.
I alter the 0cm in the ColumnWidths propery to 1cm and then set the LimitToList propery to NO. This is allowed, but, when I open the form and try to enter data into the TutorsName field (Plus all the others) I get the TutorsID numbers i.e. 1 2 3 4 etc first and then the names. The field will only allow numbers.
I think that all but just to get this correct first of all will help greatly.
Thanks alot.
Gerry

I have a form with a number of fields into which i want to be able to pick from a list of existing records and also be able to enter data to be saved as new.
The Form is basically for inputting Date, Tutors Names, Work Day Names, Course Name, Class Name, Course Level, Hours Worked, Total Hours.
When I try to set the LimitToList in the combo box properties I get an error saying;
Access can'nt set the LimitToList Propery to right now.
The first visible column, which is determined by the ColumnWidths Propery, is'nt equal to the Bound Column. Adjust the ColumnWidths Propery first, and then set the LimitToList Property.
I alter the 0cm in the ColumnWidths propery to 1cm and then set the LimitToList propery to NO. This is allowed, but, when I open the form and try to enter data into the TutorsName field (Plus all the others) I get the TutorsID numbers i.e. 1 2 3 4 etc first and then the names. The field will only allow numbers.
I think that all but just to get this correct first of all will help greatly.
Thanks alot.
Gerry
