If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 Form
I am trying to have a PO# field on a form enter an auto
number but only after the authorization field on the same form is filled in on a form. The authorization field is part of the same table (PO # Table). The PO# is related to 2 other tables, the Item Table and the Invoice Table. The Item Table is also part of the same form and is related by PO #. Is this possible. |
#2
|
|||
|
|||
Pam,
I think what you are asking is impossible if you mean that it is an AutoNumber data type. As soon as the Authorisation field, or any other field, has data entered into it, a value will be allocated to the Autonumber field. However, you could make it a Number data type, and use a VBA procedure to allocate the value, for example on the AfterUpdate event of Authorisation. You would also need to take steps to ensure that none of the fields from the Item Table table can be accessed until after the PO# has a value allocated. As a side issue, unrelated to your question, it is not a good idea to use a # as part of the name of a field or control, and I would recommend changing this. -- Steve Schapel, Microsoft Access MVP Pam wrote: I am trying to have a PO# field on a form enter an auto number but only after the authorization field on the same form is filled in on a form. The authorization field is part of the same table (PO # Table). The PO# is related to 2 other tables, the Item Table and the Invoice Table. The Item Table is also part of the same form and is related by PO #. Is this possible. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL Server 2000 Stored Procedures to MS Access 2000 Queries | CS | General Discussion | 4 | July 15th, 2004 03:27 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
Passing value to modal child form in MS Access using VBA? | Grahammer | Using Forms | 6 | July 4th, 2004 11:53 PM |
Access 2003 crash when reading read-only files in Access 2000 form | Willem-Derk Nijdam | General Discussion | 0 | June 21st, 2004 09:54 AM |