Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter

Status
Not open for further replies.

lbunch

Programmer
Joined
Sep 5, 2006
Messages
120
Location
US
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

 
How are ya lcan4 . . .
lcan4 said:
[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]

Calvin.gif
See Ya! . . . . . .
 
lcan4 . . .

I'm gonna stick with your first problem:
lcan4 said:
[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]?

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top