Help Problem with form coding in Access 2003

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi

Hope you can help. Im building a purchase order form within Access 2003 and
i would like the form to auto fill in the supplier details from another table
once i have chosen the supplier from the unique id drop down menu on the
form. Im stuck at the moment, so the any help would be great.

Cheers

Simon
 
Simon said:
Hi

Hope you can help. Im building a purchase order form within Access
2003 and i would like the form to auto fill in the supplier details
from another table once i have chosen the supplier from the unique id
drop down menu on the form. Im stuck at the moment, so the any help
would be great.
Click to expand...

Do you want to just display it (good idea) or actually copy it to bound
fields (bad idea)?

Supplier details should be stored in exactly one table (the Suppliers
table), but using various lookup mechanisms so that you can *see* that data
in other areas is a perfectly sound thing to do.

One example:
Add all the additional data as hidden columns in the ComboBox you are using
to choose the SupplierID. Then use TextBoxes to display it with
ControlSource entries like...

=ComboBoxName.Column(2)
=ComboBoxName.Column(3)
etc..
 
yeah just display the info. thanks for the help. One question how do i make
the different columns hidden? and only show supplier id?

Cheers
Simon
 
Simon

In the Combo Property

ColumnWidth

..5",0",0",0" and so on, depending on your total number of columns

Something to keep in mind.

The first column in a combobox is not Number 1, it is actually 0.

So when addressing .Column(1), you are actually looking at the second
column.

HTH
Mark.
 
Back
Top