Subform field link

[MikeLeBen]

Main form's record source:

SELECT Clienti_Ricette.*, Pagamenti.* FROM Clienti_Ricette, Pagamenti

The subform is a datasheet meant to view and possibly enter new records in the table Pagamenti.

subform's record source (from the afterupdate of a cbo in the main form):

mysql = "SELECT Pagamenti.* FROM Pagamenti " & _
        "WHERE Pagamenti.IDCliente = " & Me.cboRicetteEsistenti.Column(0) & ";"
Me.frmPagamentiSub.Form.RecordSource = mysql
Me.frmPagamentiSub.Form.Visible = True

Now I selected that the Master field "Clienti_Ricette.IDCliente" be linked to the child field "IDCliente", so that when a new record is added, that field is automatically populated. For some reason, though, it stays blank. How can I fix this?

 

[MikeLeBen]

Found the solution at http://www.pcreview.co.uk/forums/automation-object-error-t1143739.html

Apparently the main form's record source SELECT tblsuch.* conflicts over a related field, or something like that.

 

[NZArchie]

I am having the same problem. I modified my master query to have no .* field reference, but now my subform won't requery. Instead it prompts for the LinkMasterField, as if it doesn't exist

 

[NZArchie]

I found that creating a new subform through the wizard, and linking the masterfield to the control helped, as per

http://www.fmsinc.com/microsoftaccess/forms/subform/master-link-fields.asp

and

http://office.microsoft.com/en-us/a...many-form-HA010098674.aspx#BMusesubformwizard