Conditional Code on Combo

[avagodro]

I have a combo box in a subform that was displaying data from previous selections. I was able to correct that with Me.ComboName=" "

However, I am drawing a blank on having it conditional. If there is saved information in the table, it would display it, otherwise it would run the Me.ComboName=" "
I had thought of using

DLookup ("Rspns", "tblResponses", "QstnID=" & Me!QstnID)

to check the table, but as I said I am drawing a blank on the IF..Then..Else statement.

 

[barrysprout]

Not sure what's going on here but the conditional statement in the DLookup function needs to have quotation marks around the whole statement. Also use the full form reference instead of the Me keyword. So the statement should read something like:

"QstnID = criterion"

Hope this helps

 

[TheAceMan1]

how are ya avagodro . . .

Try this:

[blue]= IIF IsNull(DLookup ("Rspns", "tblResponses", "QstnID=" & Me!QstnID)), " ", DLookup ("Rspns", "tblResponses", "QstnID=" & Me!QstnID)[/blue]

See Ya! . . . . . .