Updating a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help with the following. I am trying to set up
a database which can be used for PO entry. On the
detailed subform, I would like the system to drop the
item number's description from my master table to my PO
detail description and then allow the field to be
changed. I have tried using an update query, but because
the current record is still in use it is not updating the
field when the item number is entered. What else can I
use to update the field ??
 
Use the AfterUpdate event of the Item to assign a value to the Description.

If Item is a combo box, you can load the Description into a secondary
column. The code would then be:
Me.Description = Me.Item.Column(1)
(Note: the first column is number zero.)

If the Item is not a combo, use DLookup() to retrieve the value of the
Description field from your table. For help with DLookup(), see:
http://allenbrowne.com/casu-07.html
 
Back
Top