By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Begineers question

P: n/a
All,

If I have a form with multiple fields, If I populate field with a product #,
how can I get the manufactures field to auto fill?

MTIA
--
Regards,

Mick Gaffney
mi*********@eircom.net


Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
MLH
Do you have your table relationships set up so the
mfr's table is linked to the products table in a 1-to-
many relationship?
Nov 13 '05 #2

P: n/a
Mick,
Can you give us a little more information? Are product # and
manufactures related in any way, are they fields in the same table,
does manufactures need to come from another table, is manufactures in a
combo list on the form?
Thanks
Pachydermitis

Nov 13 '05 #3

P: n/a
If the product# field is a combobox, you can have multiple columns in
it, but not show them all. then you can set the value of your
manufacturer's field to be a value of one of those columns.

Say the products table has the following fields (ProductID,
ProductName, Manufacturer).
Make your combobox have three columns.
Column Widths: 0;1;0
The Manufacturer field will be unbound and will be set to
Me!cboProduct.Columns(2)
(columns are zero-based, so subtract one from the ordinal count...)
confused yet? Great. Mission accomplished.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.