Hello everyone!
I have the following problem with date (format ‘yyyy’) in combobox: This combobox is used in a main form with more then 5 button. Each of this buttons open the new sub form on click in which the data are related with the same date in the combobox. The problem is that when you choose/click some button in the main form, after than exit of the form (automatic turn back to the main form) and try to choose some other button (to open another form) the date in combobox disappear and the “run time error 94: Invalid use of null” received.
But the real problem is that this main form work without problem to the other more than 10 (not in network) different PC-s.
The combobox has following properties
Row source type: Table/Query
Row source: SELECT Format$([YEAR],"0000") AS Expr1 FROM MODEL_YEARS; ‘Models Years is a table which contains date-year in the case 2003,2004,2005,2006 as year field is a number, field size- integer, format-fixed, decimal places-0.
That’s is. I’ll appreciate any help.
Thanks.
Linear Mode
