Data Access Page

[S Acharya]

Hi All,

I have created a Data Access(DAP) Page to append the sales order received on phone. The Data Access Page is linked to query which has autonumber field to store the Sales Order. I have a textbox on DAP for Sales Order No. The autonumber generated in Table is different from autonumber generated on DAP. I want same the autonumber on page and in table.


Thanks for time.

S Acharya

 

[Bilbo_Baggins_Esq]

Data Access Page is linked to query which has autonumber field to store the Sales Order.

the AutoNumber field for this query has to ultimately be derived from a table.

The autonumber generated in Table is different from autonumber generated on DAP

If these fields are indeed both AutoNumbers, they must be coming from different tables. The only way they will stay in sync (and also be AutoNumber fields) is if they are true 1 to 1 relationships, and if that is the case, they may not need to be in different tables.

On the other hand, not having looked at your structure, I suspect you need to add to your process(es) such that the AutoNumber value generated in one table is carried over to the other table as a LongNumber.

 

[S Acharya]

Hi Biblo,

Sorry, I was away for some time and could not respond to you.

I have created an Access Page using Design mode in Access. I have draged the Sales Order Field from the query to which page is linked. Thus Sales Order Field is only coming from query and not from two different tables.

Let me know if you have any idea. Thanks

 

[Bilbo_Baggins_Esq]

The fields in the query, from which the the fields in the page are derived, must either:
1. Be ultimately derived from tables or,
2. Be calculated using VBA function(s) which work from some previous form which ultimately is derived from data in a table.

Queries do not "hold" data.
Something is out of sync in your process.