By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

how to enter data in only one textbox in the form

P: 44
sir,
i have a form created by using a table.In the form load event,i wrote
me.allowedits=false
me.allowadditions=false
me.allowdeletions=false

now i am unable to enter data in the text boxes in the form.
But i want to enter data in only one textbox named questionno in the form
How to do this.
please help me.
May 6 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
re-enable your form
run this in the form's on_open event

Expand|Select|Wrap|Line Numbers
  1. Dim c As control
  2. For Each c In Me.Controls
  3. If c.controlType = acTextBox Or c.controlType = acComboBox Or c.controlType = acCheckBox Then
  4. strName = c.Name
  5.     If c.Name = "mytextbox" Then
  6.         c.Enabled = True
  7.     Else
  8.         c.Enabled = False
  9.     End If
  10. End If
  11. Next c

this will enable only your textbox
May 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.