| | |
|
|
|
Trouble with Form, please help !!!! |
|---|
| message from shoa on 30 May 2004 |
Hello
I have two tables: one is "Sale Table" with Invoice No (primary key), Date,
Customer ID. This table is empty.
Another table is the Customer Table with Customer ID (primary key), Title,
Last name and First name. This table have some records.
My task is to create a "Transaction Entry Form". In this Form, I have to
enter Invoice No, Date, Customer ID, and Price (it is similar to Sale
Table). This table help users to enter data for each Transaction.
What I did is I create a main form from the "Sale Table" with three fields
(Invoice No, Date and Customer ID) plus a field for Price. Then I create a
SubForm from the Customer Table. In this Subform, I create a combo box for
the Customer ID, so that each time I change the Customer ID, the details of
the records will be shown. These are simple task.
What I want is each time when I change (or select) the value in the Customer
ID in Customer Table, that value must be presented in the "Customer ID" of
the main form.
Therefore, I have a code for the Customer ID in the Sale Table (the main
form) "=[Customer Table].[Form]![Customer ID]".
By using that code, each time when I change (or select) the value in the
Customer ID in Customer Table, that value is presented in the "Customer ID"
of the main form.
However, the value of Customer ID can not be saved when I enter another
transaction record. (But other values: Date and Invoice Number are
saved!!!!!).
Could you please tell me why (I already create relationship for the two
tables.)
I also used the code "=[Customer Table].[Customer ID]". But it does not work
also
Many thank
S.Hoa
|
|
Archived message: Trouble with Form, please help !!!! (Microsoft Access Database)
