Adding a new record

[molly pup]

This may seem basic but I need some help.

I have a table of vacinations and need to add a new record every time an animal is vacinated. I have created a form with all the fields in the table in it. But when I open it it takes me to the first record. I have had to add a button to the form to add a new record. This button then takes me to a blank form where i can input data. This is very messy and not very user friendly. Any suggestions on how i can tidy this up would be appreciated greatly.

 

[DES]

Seems to me that what you really need to do is to use a sub form for the vacinations.

The main form would be for the pet the sub form would contain the vacinations for that pet.

If you have problems setting this up let me know and I will see what I can do about sending you a sample.

DES

 

[Lol Owen]

In the short term set the data entry property to "yes" in the properties box for the form. his will bring up the form with a blank record ready for entry to every time the form is opened.

Lol

 

[molly pup]

Thankyou both. Your help has been most greatfully recieved.