Automatic insertion of information

  • Thread starter Thread starter Robo-robbie
  • Start date Start date
R

Robo-robbie

Can anybody help!

Because of repetitive inputting of information, I want to be able to do the
following:-

Within Form 1 select an item from a drop down box e.g. Item 5.
Item 5 also relates to description 5, cost of 5 etc.
Once I have selected Item 3, description, cost and any other information is
automatically imported into Form 1!

Is this possible?
 
To start with, you might want to think a bit more about how you have
organized your data. This kind of operation can often be avoided by properly
normalizing the data so you do not store repetitive data.

However, what you want to do is definitely possibe.
Create the combo with a column for all the items you want to automatically
insert, but hide the items you want to paste by setting their column widths
to 0. Then, in the OnClick sub for the combo you can use the Column propety
of the combo to paste the data for each column into the appropriate texbox.
Be aware that the column index starts at 0.

Check the Access bulit in help for the details

Ragnar
 
Can anybody help!

Because of repetitive inputting of information, I want to be able to do the
following:-

Within Form 1 select an item from a drop down box e.g. Item 5.
Item 5 also relates to description 5, cost of 5 etc.
Once I have selected Item 3, description, cost and any other information is
automatically imported into Form 1!

Is this possible?
Click to expand...

You'll have to explain the problem a bit better.

Remember that you don't "IMPORT" data into a Form. A Form is not a
container for data - it's a window onto data stored in tables. If
you're trying to store data redundantly, copying it from one table
into another table, DON'T. It's neither necessary nor a good idea!
 
Back
Top