Requery in a SubForm

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Dear All,
I am normalising a database, used for sending samples to the customers and
in a "SubForm" in datasheets view, I am not able to requery a field.
The form is so composed:
main form[frmDataEntry]
subform [frmSample SubForm]

Subform fields:
[Prefix] [Sample] [CustomTariffN°]
Fruit Apple 11111222233
Fruit Pear 88884444422

If in the first combobox field (Prefix) I choose the family (Fruit) in the
second
combobox field (Sample) all the products belonging to that family should
appear, but
that doesn't work.

The query, situated under the Sample field is so composed:
Prefix Sample CustomTariffN°
||
[forms]![frmSample SubForm]![Prefix]

and its routine is as follow:
Private Sub Sample_AfterUpdate()
Sample = Sample.Column(1)
CustomTariffN° = Sample.Column(2)
End Sub

Have you any idea in order how to solve the problem?
Tia,
Marc
 
I had a similar porblem. Here is the solution a coworker came up with.

[forms]![<Place name of main form hear>]![frmSample SubForm]![Prefix]

Darren
 
Back
Top