1

Topic: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

Good afternoon!
There is a Form on it sheet boxing and the subordinate form (sm an example). How to make what at event in sheet boxing for example cliques, to update the data in the subordinate form. And all it to make  VBA. In advance Thanks! For the guru already a file  there write , and I all head broke that as it to make!

2

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

SergeyL1986,

3

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

Yes, there there will be a request which pulls out all  and places in . !

4

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

I ask the help)
I use the same method as well as in an example
Me. PodForma. Form. RecordSource = "select * from tblRecom where AutoID=1"
Produces an error "Method or data member not found"

5

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

SergeyL1986;
Lay out an example

6

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

From zero created new  and does not work though I write  the account the same

7

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

Error found)))

8

Re: [In bookmarks] [an answer Window] #1 SQL request for the subordinate form vba - MS Access

SergeyL1986;

Me. PodForm. Form. RecordSource = "SELECT Users. UserID, Users. UserFIO, Com. ComTxt FROM Com INNER JOIN Users ON Com. UserID = Users. UserID where Users. UserID =" AND Me. List1