Consignee and contact

[antonov]

I have 2 tables: Consignee and Consignee_contacts.
Data concerning the Consignee is input in a form. For the consignee I have a
combobox and the data concerning the Consignee will appear automatically
(thanks Ken Snell). What will not appear is the contact (s). how can I
achieve that?

 

[Arvin Meyer [MVP]]

The contacts should be in a subform with a master/child link set to the
ConsigneeID field. Either you need to rebuild the Link, and/or add the
fields necessary to do so.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[antonov]

It is already so... but how can I recall the data?

 

[Arvin Meyer [MVP]]

If the subform/subreport is bound to the data, it is "recalled"
automatically. The data in a combo box depends upon having sufficent columns
to show the columns in the underlying table or query. So if your table or
query has 10 columns and you want the first 4 included in the colbo, you
need to set the column count property in the combo box to 4. Then set the
column width to the columns you wish to see during a dropdown (Something
like: 0";1.5";1.5";0") You can refere to a column in a text box and show the
contents of the column like this:

=Forms!MyFormName!MyComboName.Column(3)

which would show the contents of the 4th column.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access