Autonumber on form - automatic generate of new record ?

[Lukael]

Hello,

I am working on school project. I created priority table that has primary key (ID number) and other data, and three tables(also with data) that are linked to this table, with ID number of priority table and primary keys of other tables (relations many-to-many, I formed tables between them).

Problem: - my solution is created so that I can fill all neccessary data of ALL tables in ONE FORM. But ofcourse Access wants you to enter at least one field in primary table for opening new record, so that It links you to all other tables (in my case with ID number) - then It is possible to enter data of all other tables in whatever tab order you like.

What I want to do is that my autonumber field from primary table would automatically open a new record number when opening the form, without entering any data to primary table. Is that even possible ?

So far I tried to add another field in my primary table (Date/time format) and set the date to =Now(), and used macro of Refresh on form, but nothing happens. Date is shown in field, but Autonumber doesn't generate new number of record. maybe I did it wrong...

Any other idea, or maybe option to lock Tab order and force user to fullfill data only in desiring order ? I want to make solution more user friendly

P.S.: I'm using Access 2003, professor demands It, not my choice :banghead:

Thanks for your help,

Regards,
Luka

 

[jdraw]

Please describe for us in plain English WHAT you are trying to do. Forget the PK and all Access terms. Once we understand WHAT you are trying to do,someone will offer options as to HOW it may be accomplished.

This doesn't help

Problem: - my solution is created so that I can f...

 

[Lukael]

I thought I was clear... Ok, question is - Can I open my form which is made from "leading" table and linked subforms(tables) in that way so that AUTONUMBER field woudn't be set as "Autonumber", but It would already assign new number of record without entering nothing (As it does when you enter data in "leading" table field) ?

Regards, Luka