Combo, List, and Subform Problem

[RichB]

1. I have a form with a combo box that lists equipment from a table.

2. I have a list box that lists status dates for the piece of equipment selected in the combo box.

3. I have a subform with the status information that should show when you click on a date in the list box. When I click on the date I get this error message.

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expressions to variables."

I have done this multiple times with success and have never seen this error.

Any Insight would be appreciated.

RichB

 

[wizcow]

RichB

If it was working, and you haven't changed anything, and now you get this error, I would guess that Access, Windows, or your computer, have lost their mind.

Try Compacting your databse
Tools>Database Utilities>Compact and Repair...

Maybe even restart your computer.

Hope that helps

Tom

 

[RichB]

I was not clear. I have done this with other database projects. For some reason it doesn't work with this one. I am not sure why.

I did try to compact and repair and it had no effect.

Thanks

 

[RichB]

I have attached the db so maybe someone can help. I believe I have left all applicable elements. I think this will make my question very clear.

Thanks
Rich

 

[saharlan]

solution

Hi Rich,

Your problem is in list4 you need to change your bound column
from 1 to 2.

This is because your subform is looking for acft;edate
from combo2;list4 and your query is returning 3 variables
acft, edate, and ttrans but you have set your list to
0";0.7";0.4" so acft doesnt show up but it is still logically
in the first position.

therefore your were trying to match up acft;acft with acft;edate

hope this helps!!