Validate with code Yes or No

[GinaFlan]

I need to validate yes or no with code. I thought this would be easy. Access does not like "Not in"


If (Me.TxtActualBenchmark) Not in "Yes" or (Me.TxtActualBenchmark) Not in "No" And txtBenchmark.value = "Free lunch for all students Yes/No" Then
MsgBox "Please answer Yes or No"
Exit Sub
End If

[ranman256]

not YES
or
not NO

dont use IN

[GinaFlan]

Ok Thank you I will try it

[Missinglinq]

Is the Field that is Bound to TxtActualBenchmark defined as Text or Boolean Datatype?

Linq ;0)>

[GinaFlan]

It is defined as text. I still can't get it to work

[June7]

The conditional statement doesn't really make sense.

If TxtActualBenchmark must be either "Yes" or "No" then the Or operator doesn't work.

Maybe:

If (Me.TxtActualBenchmark) <> "Yes" And (Me.TxtActualBenchmark) <> "No" And Me.txtBenchmark = "Free lunch for all students Yes/No" Then

Or:

If IsNull(Me.TxtActualBenchmark) AND Me.txtBenchmark = "Free lunch for all students Yes/No" Then

Maybe TxtActualBenchmark should be a combobox with only two items listed.

[GinaFlan]

Yes it has been quite a challenge. I am building it for a department head in another department. I will try that and see if it works. Thank you

[GinaFlan]

Maybe there is another way to say it.

[GinaFlan]

I'm going to look at it again in the morning it's 7:00 over here

[GinaFlan]

ScorecardsGina.zip This is the form

[June7]

1. Main form is bound to Geans (actually an SQL statement pulling from Geans but could just be the table), however no controls are bound to fields so why is there a RecordSource?

2. Geans does not have a primary key field. It appears data is being duplicated into Scorecards table. There is no relationship between Geans and any other table. What is this table for?

3. None of the tables have a primary key defined, yet there is a link between Scorecards and BusinessDepartment on common Groups field - which is the primary and which is the foreign key field?

4. Why have code behind main form to create records into Scorecards table when the subform is bound to Scorecards and data can be directly input through subform?

5. This could be one form - set the form for Continuous View, move unbound controls and buttons into form header and Scorecards fields stay in detail section, arrange controls in detail to appear as datasheet. Maybe you should explore the Split form object.

6. One way to force data entry into bound controls is to set fields as Required in the table then Access will nag the user to enter data before the record can be saved. No code required.

7. The RowSource for Fiscal Year combobox will have to be edited every year. The RowSource can be constructed by code or by reference to a table of years.

Have you done a thorough analysis of the database specifications? Have you identified all data entities and relationships? Should get data structure established before trying to build GUI and code. Perhaps this site will be of help http://www.rogersaccesslibrary.com/