Required.Value

[InFlight]

I am using VBA to change [myTableName]![myFieldName]!Required.Value = -1
I am getting error
Error 2465 Can't find field '|1' referred to in your expression

 

[pbaldy]

What is your actual code? You can't just refer to a table like that.

 

[InFlight]

Hi
I think i may have got it by trial and error
Is this correct

    DoCmd.SetWarnings False
    db.TableDefs("Patronage").Fields("PatronageId").Required = True
    DoCmd.SetWarnings True

 

[pbaldy]

If it works, it's correct.

You haven't declared or set the db variable. You can probably use CurrentDb instead, and you don't need the SetWarnings lines (I don't think anyway).

 

[InFlight]

Sorry about that. It is set earlier

 

[pbaldy]

So did it work?

Say hi to my daughter!

 

[InFlight]

Yes it did.Thanks
I am still learning.

Cheers

 

[pbaldy]

No problem.

 

[Pat Hartman]

DoCmd.SetWarnings False
db.TableDefs("Patronage").Fields("PatronageId").Required = True
DoCmd.SetWarnings True

I'm not sure what this might be doing but it isn't an update query. Are you trying to set the required property of a field to true?

 

[pbaldy]

It does set the required property to true, yes.

 

[Pat Hartman]

It was the .Value reference that confused me.

 

[pbaldy]

Post 3 didn't clarify it?

 

[Mark_]

Odd question, why are you setting it as required at the table level by code instead of simply updating the table definition?

 

[InFlight]

not to me.