Recent content by whirlygig

Re: Update: Retain values of comboboxes I found this error came from the RowSource in Properites - the source was a query and it said: "SELECT [.tblMode].[.lngModeID], [.tblMode].[.lngTypeID], [.tblMode].[.strFailMode] FROM tblMode WHERE [.lngTypeID]=1;" I removed the WHERE clause to get...

Yes, they depend on each other like that. However I need to be able to run filters on the value of each combo box later, for a report. We test the product before it leaves, and run the same set of tests if it is returned. Rather than having maintenance write a freehand description of the...

Update: Retain values of comboboxes I did bind the controls to the table they should save to, and when I look at the table they seem to have saved. However, when I open the form I get an error "Enter Parameter Value: Val-A" (for cboBox1). The answer put there does not seem to affect the data...

The requirement I was given is to force the choices. The option lists are stored in separate tables with the foreign keys to relate them to each other. I need to store the selected options from the boxes in a separate service call form that the repair person will complete, using the combo boxes...

I have four levels of cascading combo boxes (level 1 filters level 2, which filters level 3, etc). On the form they are unbound controls, but I need to collect and store the data in the table behind the form. How do I do that? I've been searching the internet and cannot find anything so far. I...