Automatic filling fields (1 Viewer)

[QueryStumped]

Creating a form, one field is a combo box, either available or not available. Need to have another field to automatically update to yes or no based on the combo box. I do not know SQL. Any guidance is very appreciated.

 

[jdraw]

Please tell us in plain English what you are trying to do --no database jargon. Just some context, not how you have tried to do something. It's the something that users want to know. There may be options for how.

 

[QueryStumped]

I have a form where the user will choose available or unavailable from a combo box. I want to automatically have another box that will have a field to show Yes or No depending on what they chose from the combo box field. How do I program that, based on the combo box?

 

[bastanu]

In the AfterUpdate event of the combo box add something like this (use your own control names):

Private Sub cboAvailable_AfterUpdate()

me.YesNoFieldControl=iif(Me.cboAvailable="Available","Yes","No")


End Sub

Cheers,
Vlad

 

[QueryStumped]

Thank you! I really appreciate the help. I will have to fix it when I get back to work.