Formatting Question

  • Thread starter Thread starter Someone Curious
  • Start date Start date
S

Someone Curious

Hi All

I am still having a problem with a modification I need to make. Hopefully if
I explain better it may help. Thanks in advance of any help.

I have an existing report which works fine.

I have added some check boxes. Dependant on a text field in the same record
I may want to turn on or off the checkbox. I am open to any suggestions. I
have been trying the following to no avail.

I have tried the following to make a procedure in the onformat event of the
detail sheet.

Inside routine......

if [My Actual Table.FirstName].value = "Fred" Then
MySubRoutine
else
MyOtherSubRoutine
end if

This tells me the field does not exist. It is spelt correctly.

Regards
John
 
Curious,
If the field on your report is named FirstName, refer to it as...
If [FirstName] = "Fred" Then...
or
If Me.[FirstName] = "Fred" Then...
 
You must log in or register to reply here.

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

Newbie Qusetion 3
Concatenation 1
VBA - Alternate ways to call code in "PowerPoint Objects"? 7
Terminate main procedure from a subroutine? 4
Check if a date exists in a record 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
How do I close a record set that is not open? 4
Problem with form--subform 5

Back
Top