Views as Recordsource for .adp forms

[BlackKnight]

Hi folks,

Can a view be used in an .ADP form's recordsource, in which the form is used to add new records to the underlying tables?
When I use DoCmd.GotoRrecord ,,,acNewRecord I receive an error message, "Can't go to specified record" Thanx in advance.

Have a good one!
BK

 

[foxdev]

Does the view reference more than one table?

Robert Bradley

http://www.foxdev.com/

 

[BlackKnight]

Hi Robert,

Yes, the view does refer to multiple tables. I think I solved the problem by setting the uniquetable property to one of the referenced tables. I discovered it after submitting the eaarlier post. Thx for the help.

Have a good one!
BK