Unique Table dropdown is blank

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
 
S

Sylvain Lafontaine

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.
 
W

Wes Peters

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top