Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subform based on a secured table

Status
Not open for further replies.

bigblueogre

Technical User
Mar 20, 2007
1
US
Hi,
I have a form/subform setup that works good until I removed privileges from the underlying table.
I made the subform based on a query with RWOP on it. It works just fine when opened directly, but when opened in the main form, it just shows as a white box.
The datasource on the subform is

SELECT [Sales].SalesID,
FROM Sales
WITH OWNERACCESS OPTION;

What am I doing wrong?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top