Set Focus on Subform

S

selgin

This is Access 2003.

I have a parent form - PatientForm2 and a child form - Rx.

I am trying to set the focus to RxStatus on my Rx subform if it is blank and
DateComplete has data entered.

This is the current code I have. The message box opens up but thats it.

If IsNull(DateComplete) = False And IsNull(Me.RxStatus) = True Then

MsgBox ("Rx Status cannot be Blank")


Me.RxStatus.SetFocus

Me.Repaint
Else

End If

TIA for any help

Steve
 

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

Set as Default Template not working 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Unremovable horizontal scroll bar on subform 1
Set focus in a specific record within a subform 1
Focus to SubForm Control 10
Go to a Specific Record on a Subform 3
Making a macro only work on certain files 2
How to set Subform Default Focus 1

Top