Automatically fill in some fields in data entry form

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!!
 
M

Mark Andrews

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry to Form with repeat data. 13
Data Entry tab under Records tab 1
Automatically enter values in fields in a table 1
Opening form showing no data in fields 2
Basing one data entry form on a previous record 6
Retrieving data from subform 1
Access Automatically Send a notification email once a record is added 0
How do I auto-populate new records with data from another table? 1

Top