Re: Filling in a field based on data in another table
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 08:40:07 -0600
Make the Custeomr_Number entry into a combo box with with the second column
of the Row Source returning the Customer_Name. Then in the after update
event of the combo box, use code like:
Me.txtCustomer_Name = Me.cboCustomer_Number.Column(1)
This makes some assumptions regarding your control names.
--
Duane Hookom
MS Access MVP
--
"bvdahl" <bvdahl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:574E8456-D1DC-44F8-A47C-20A398C9B3C1@xxxxxxxxxxxxxxxx
>I have two tables: purchase_orders and customers. Both the tables have a
> 'customer_number' field. In both tables, there is a field called
> 'customer_name'.
>
> I want this field in the 'purchase_orders' table to be updated with the
> corresponding value in the 'customers' table when I fill in a value in the
> 'customer_number' field. However, if 'customer_number' is left blank, I
> would
> like to be able to fill in the 'customer_name' manually.
>
> So, in short, I would like to be able to generate purchase orders without
> NECESSARILY having a customer number.
>
> Any ideas on how to achieve this?
>
> Regards
>
> Baard
.
- Prev by Date: RE: Help with functional design of MDB data
- Next by Date: Re: Retention of records
- Previous by thread: RE: Help with functional design of MDB data
- Next by thread: Re: Retention of records
- Index(es):
Relevant Pages
|
