Filter

[lbunch]

I have an OnLoad event that uses


Me.FilterOn = True

I need to add a primary key to the table and when I do I get an error on this line.

And I added
Me.Filter = "emp_nbr"
Me.Filter = "emp_id" which are primary keys then i get an error or my me.Requery's where I requery the forms which I need to do to refresh the data. I have Required fields on the forms also. And one form uses requery and another one uses refresh and the forms a basically the same format.


So I have three issues

- me.filter(
- requery with primary keys set and
- Required Fields

 

[TheAceMan1]

How are ya lcan4 . . .

[blue] . . . I need to add a primary key to the table and when I do I get an error on this line . . .[/blue]

. . . [blue]and how are you adding the primarykey?[/blue]

See Ya! . . . . . .

 

[lbunch]

on the table...

 

[TheAceMan1]

lcan4 . . .

I'm gonna stick with your first problem:

[blue]I need to add a primary key to the table and when I do I get an error on this line.[/blue]

Are you entering the primarykey:
[ol][li]Directly in the table ([blue]table view[/blue])?[/li]
[li]Thru a form ([blue]typing in the primarykey field[/blue])?[/li]
[li]Thru code in VBA?[/li][/ol]
By chance is the primarykey of type [blue]Autonumber[/blue]?
If not not what is the data type [blue]Numeric/Text[/blue]?

See Ya! . . . . . .