Unique Table dropdown is blank

  • Thread starter Thread starter Wes Peters
  • Start date Start date
W

Wes Peters

I have a form that has a stored procedure with joined tables as its Record
Source. When I go to set the Unique Table property there's nothing in the
dropdown. I can't edit the record without specifying a unique table. I've
included the key field in the sp for the table I want to update. What am I
missing?

Thanks,
Wes
 
This is a known little bug of ADP. Set temporarily the RecordSource to the
same value as the unique table, change the property for Unique Table and
then reset the RecordSource to its real value.

You can also set the Unique Table property with VBA code in the form's
OnOpen event.

S. L.
 
That worked. Thanks again for your help.
Wes

Sylvain Lafontaine said:
This is a known little bug of ADP. Set temporarily the RecordSource to the
same value as the unique table, change the property for Unique Table and
then reset the RecordSource to its real value.

You can also set the Unique Table property with VBA code in the form's
OnOpen event.

S. L.
Click to expand...
 
Back
Top