New records in tables and forms...where are they?

[smhill]

I tried to add a new record to my table, but it doesn't show up on the corresponding form. If I try to add it to the form, I'm told one of my fields is prohibited by the validation rule. The validation rule is >=010001 and <=019999. I'm entering 010035, and it's telling me it's prohibited. What am I doing wrong?

 

[Mel Henderson]

where are you putting the validation rule info, when I put your >010001 and <019999 in the table and add that field to a form it works fine. Maybe you can give a little more detail about your problem.

 

[smhill]

I didn't create the database. My company is working with another and this is the way we send all our information back and forth. They sent me the database with all the forms so I could enter my info. When I recieved it there were 100 records partially filled out that I was supposed to complete. Now I'm done that and I have to start adding new records, but wherever I try to add a new record (to the form or tables) it doesn't show up on the other. I get messages that don't make any sense, such as the one I mentioned before. Where my validation rule is >=010001 and <=019999, there is already an entry of 010033 and 010034, but it tells me 010035 is prohibited. Now I'm getting a new message. It's telling me I have a null value where there is clearly a value nearly identical to those that work. I know I must be doing something wrong in entering new records. If I enter them into the table, is there something I have to do to make it show up on the form?