Question Locked

How to use query result as default value in Access

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Access 2003, I design a customer order processing database. There are several tables, Customer (customer code, customer name, dept, salesman, ...), Order (order number, customer code, dept, salesman, ...). How to realize: for order entry, when select one customer, then default value for dept, salesman in the order can be set same as in Customer, but user can also change to other dept or salesman?

1 reply

This discussion is closed to new replies.