combobox answer disables rest of feilds on form from having data entered in

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

i have a combo box on a form - its a survey...if u select YES for a in this
combobox the rest of that inparticular form becomes so that the user cannto
enter in anything into the fields that were left and must proceed to the
next page.

in after update event of community garbage disposal combo box this code
deosnt work and gives me this error: ms access cant find the macro If
CommunityGarbageDisposal = "YES" Then
| Me

If CommunityGarbageDisposal = "YES" Then
| Me.AllowEdits = False
| Else
| Me.AllowEdits = True
| End If
|
| Exit_cmdClose_Click:
| Exit Sub
| Err_cmdClose_Click:
| MsgBox Err.Description
| Resume Exit_cmdClose_Click
|
 
answered in your other post.


|i have a combo box on a form - its a survey...if u select YES for a in this
| combobox the rest of that inparticular form becomes so that the user cannto
| enter in anything into the fields that were left and must proceed to the
| next page.
|
| in after update event of community garbage disposal combo box this code
| deosnt work and gives me this error: ms access cant find the macro If
| CommunityGarbageDisposal = "YES" Then
|| Me
|
| If CommunityGarbageDisposal = "YES" Then
|| Me.AllowEdits = False
|| Else
|| Me.AllowEdits = True
|| End If
||
|| Exit_cmdClose_Click:
|| Exit Sub
|| Err_cmdClose_Click:
|| MsgBox Err.Description
|| Resume Exit_cmdClose_Click
||
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

disable data entry/editing for rest of form if condition is met 8
Adding data to a Form from a Form that's being closed 4
Set ComboBox entry 2
Force data entry of certain fields on a form 8
Filtering a form based on selection from combo box in another form 1
ComboBox Condition from first Form to a second one. 2
Referring to control on form from subform 1
form: cursor stays on field until user enters data 2

Back
Top