Issues with Default combo box value based on table yes/no field

[websterh]

Hi all,
I've searched and searched and tried variations for several hours with no luck. I have experience in creating register, activity and clinical databases.



My database is an activity collection tool/database, each activity would have a question identified to it. And will eventually be split.

My issue is the "Default value" for a Form field- named 'Question' - sourced data from table 'LU Question' i have the fields Question/Visible/Default/MonthUsed; with the Visible and Default being Yes/No.
( Visible :: Yes = shows only those questions ticked on the form/combo box -- so this works fine )
( The Default :: Yes = does not display, I'm having issues with the correct code assignment - done so through the Form Design, Combo box properties, Default value option/selection )

I would like the question, that's selected as Default in the LU table, to show up automatically in the Combo box on the Form.

Names of the form/fields are:

• Form: HarmMinEF
• Question/Combo box: Question
• Lookup table / field / value name: LU Question / Default / Yes

I have attempted variations with the way to retrieve the default and select it, but none worked (even tried doing a query to pick the Yes=Default from the LU but doesn't display - always comes up with #Name? (this appears for my other attempts too)).

Any help withthe code or source would be appreciated.

[June7]

Want to provide project for analysis?

[dblife]

please see attached db showing how this can be done.
you can use the formload event to make it happen.
when the form loads, the vb code uses the 'dlookup()' function to call up the value of the record where default is 'true'
this numeric value goes into the combo as default, but because the key value has it's width set to '0', the queston appears in the combo.
hope this helps.

[websterh]

Thanks for the post and example, dblife, although it did work on the load it doesn't on the update as it counts a new record when 'add new record' even when not selected any fields like you'd normally would.

To cut myself free 'fancy' d lookup of this i've decided to copy/paste the 'Question' to the default property on the combo box.

I'd have to update the Default yes/no anyway so ...... yeah/that's it.
Thank you.

[dblife]

very welcome..