Automatically fill in some fields in data entry form

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I have an inventory system, and want to develop a data entry form. I need to
enter a part number (drop-down list format) and have some of the fields
populated by other information in previous records in the same table
(information doesn't change that often). The fields also need to be
updatable in the new record only, not in existing records. I'm just
struggling with the way to auto-populate some of the fields in the new record.

PLEASE HELP!!
 
Some normal ways are:
- have the part number dropdown have multiple columns (where most are hidden
(0 width)) and then
populate controls as Me.txtWhatever = Me.comboPartNumber.Column(2)
or
- use Dlookups to pull in values where you use the part number as criteria

HTH,
Mark
RPT Software
http://www.rptsoftware.com
 
Back
Top