Open form to new record

[ChrisGow]

I want to make a form where I can only make a new record. I basically need a normal form that opens and automatically clicks the new record button. I do not want to be able to view and of the other records, only see the new record that I am putting in.

 

[still_rookie]

also change 'navigation buttons' to - NO... that way, the bar at the bottom of the form by which you can browse through the records, is diabled.

 

[ChrisGow]

What The Hell

OK I got that to work so that I can input new records. Thanks for that.

On the form that I open I am using an auto number to create client numbers. My table has numbers that go up to 18, but when I go to enter a new client, it is not 19. I think that my autonumber has counted up too high from me testing it. Is there anyway to get that so that it always looks at the last number in the table instead of the last number that it used

 

[borolee13]

Chris,
Have compacted your database???

I think this resets the autonumber

 

[wazz]

DoCmd.OpenForm "frmAddMovement", , , , acFormAdd

in the form's properties, on the 'Other' tab, set Cycle to Current Record, if you want.

 

[ChrisGow]

ok I have noticed that this is not a form problem but something that deals with the table.
The table has the same autonumber problem.
Does this help anyone see a simple solution

 

[ChrisGow]

I think what I am going to do is have it behind the scenes. The only reason I actually need it is for access. Thanks for the help everyone.