Subform problem-User Type not defined

[magster06]

Hello all,

I have a subform on a tab of my main form.

I get an error message: The Link Master Field property setting has produced this error: User type defined not defined.

I noticed that this happens when I navigate to a record in the subform that does not have any values.

For instance, when I navigate from the navigation controls on the bottom of my mainform 1,2,3, etc ( and the subform does so accordingly), lets say I have a record 4 in my main form, but not in my subform; this is when the error is produced.

Any ideas?

 

[boblarson]

If you have the correct field in the Master/Child link, you will not get this error. You cannot navigate to a record in the subform that doesn't exist. So, not sure exactly how you set this up, but a couple of things to look at:

1. The record source for the main form should not have any table in it that appears in the subform record source.

2. The record source for the subform should not have any table in it that appears in the main form record source.

3. There should not be any lookup tables in either of the record sources. Those are handled by the rowsources of combo's and list boxes.

 

[magster06]

Thanks again Bob! You hit the nail on the head again.