Refresh

N

nat

I wrote a code to disable :

If Me!USCitizen = True Then
Me!EmploymentCardNo.Enabled = False
Else
If Me!USCitizen = False Then
Me!EmploymentCardNo.Enabled = True
End If
End If
you can enable/disable textbox or whatever on that
record, but My problem is when i click on next record,
disable code still show on next record.

My question is how can i refresh the form so that what
ever I disable on record#1 will not show on record#2

Thank you
 
R

Rick Brandt

nat said:
I wrote a code to disable :

If Me!USCitizen = True Then
Me!EmploymentCardNo.Enabled = False
Else
If Me!USCitizen = False Then
Me!EmploymentCardNo.Enabled = True
End If
End If
you can enable/disable textbox or whatever on that
record, but My problem is when i click on next record,
disable code still show on next record.

My question is how can i refresh the form so that what
ever I disable on record#1 will not show on record#2
Click to expand...

Copy (or call) your code in the form's Current event. You can also simplify your
statement to...

Me!EmploymentCardNo.Enabled = Not Me!UsCitizen
 

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

Select Text to End of Footnote 9
Need Help with Macro Security 1
Macro to Select text from a point given to a specific word 2
Loop through pages and insert header image 0
VBA - exporting serial letters to single documents 0
Making a macro only work on certain files 2
Improving Macro That Keeps First Letter 0
VBA word change keys 0

Top