Pesky subform error

[Guest]

I have a personnel table which includes staff grade as a field, I have a
second table (tbl.grade)with staff grade and salary rate as the only two
fields. The value for the grade in the first table is inserted from a drop
down list whose source is the grade field in the second table.
I have a data entry form for all fields in the first table, which I want to
display the salary rate for that persons grade.
I have done this by creating a form based on the second table ,called
frm.grade, and inserting this as a subform on the data entry form
The tables are linked by the sub form field linker on the grade field.
When I cycle through the records on the data entry form it seems to work
until I reach record 20 it then produces the error:

The link master fields property setting has produced the following error:
Invalid outside proceedure

The help button refers to a filter which I cannot remember setting
Can anyone point me at what may be causing this error?
I can't figure it out .
Thank You

 

[Wayne Morgan]

The combo box will only show one column after you make the selection. Are
you just wanting to show the salary also? If so, you don't need a subform to
do that. You could place a textbox next to the combo box or elsewhere on the
form and set its Control Source to the second column in the combo box. This
will display the salary.

To do this, return both columns from the lookup in the row source of the
combo box. If you don't want the salary to show when you drop down the combo
box, then set the Width of the second column to 0 on the combo box's Format
tab. Next, set the Control Source of the textbox to

=NameOfCombo.Column(1)

The column number is zero based, so 0 is the first column, 1 the second,
etc.

As far as the error you're receiving, I suspect that there is a problem with
the data in that record. If you sort the records in a different order does
it still fail at 20 or does the failure follow the record? Is 20 a new
record or an existing record?