unbound textbox in subform not allowing input

B

Bruce Pearson

I have an unbound textbox that will not allow input entry when the form is open as a subform

What's up with this

Thanks
B
 
M

Michel Walsh

Hi,


I would try, in the Load event, to lock (or disable) the text controls
if the form has a parent:

Dim IsUseAsSubFom As Boolean

On Error Resume Next
Me.Parent
IsUseAsSubFom = CBool( 0=Er.Number)

Me.Control1.Locked= IsUseAsSubFom
Me.Control2.Locked= IsUseAsSubFom


Hoping it may help,
Vanderghast, Access MVP
 

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

DLookup in Continuous form 0
update textbox with total 9
populate to subform 3
Continuous subform behavior 7
main form/subform 1
Filter Subform 1
DataSheet Sumary 12
Appending unbound textboxes to another table 1

Top