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.
Click to expand...
 

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

Similar Threads

Setting column width in a table with a macro is not working 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Bug? 6
Consolidation Table from Different Excel Tabs with Different Format 1
Dealing with a Pivot Table (when I don't want to) 0
Adding data to MS Access from csv file 0
Unique Table Property 1
Linking data in MS Word into Excel 5

Top