<div>
Ok. I actually typed in<br />
<br />
I will do as you suggest doing the following<br />
<br />
Create a Backup<br />
delete form<br />
decompile<br />
complie<br />
compact<br />
import form<br />
compile<br />
<br />
let's see what happens
</div>


Ok. I actually typed in

I will do as you suggest doing the following

Create a Backup
delete form
decompile
complie
compact
import form
compile

let's see what happens

<div>
thanks for pointing me to the right &nbsp;directiion. Actually the error was on de code to generate the query (alright) but, on the form the code was using anther query!
</div>


thanks for pointing me to the right  directiion. Actually the error was on de code to generate the query (alright) but, on the form the code was using anther query!

<div>
<div class="content wysiwyg-content">
On my MS/ACCESS app I have a form that contains a master field, named [fld_marcacaoSelecionada].<wbr /> On open the field is correctly computed and show a proper value.<br />
<br />
The I have a subform, based on a query, that also is correctly computed. The query contents are OK.<br />
<br />
The subform is supposed to present all query records that are related to [fld_marcacaoSelecionada] in the masterform. So, in subform, I have an hidden field named [fld_codMarcacao] whose content directly comes from a column in th query named [codMarcacao].<br />
<br />
However, when I start the masterform it ask &nbsp;me for the parameter [fld_codMarcacao] (?) and when I use [codMarcacao] on the liks master/child, it crashes.<br />
<br />
Current the links are:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w16/1158087/Screen-Shot-2017-04-22-at-11.48.06.png" target="_blank" title="Screen-Shot-2017-04-22-at-11.48.06.png (33 KB)"><img alt="Screen-Shot-2017-04-22-at-11.48.06.png" class="file-block lazyload" style="max-width: 702px;" data-src="https://filedb.experts-exchange.com/incoming/2017/04_w16/1158087/Screen-Shot-2017-04-22-at-11.48.06.png" /></a><br />
<br />
can anyone help? (I am able to share the code)
</div>
</div>


Screen-Shot-2017-04-22-at-11.48.06.png

On my MS/ACCESS app I have a form that contains a master field, named [fld_marcacaoSelecionada]. On open the field is correctly computed and show a proper value.

The I have a subform, based on a query, that also is correctly computed. The query contents are OK.

The subform is supposed to present all query records that are related to [fld_marcacaoSelecionada] in the masterform. So, in subform, I have an hidden field named [fld_codMarcacao] whose content directly comes from a column in th query named [codMarcacao].

However, when I start the masterform it ask  me for the parameter [fld_codMarcacao] (?) and when I use [codMarcacao] on the liks master/child, it crashes.

Current the links are:




can anyone help? (I am able to share the code)

ms/link form - subform field not recognised

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.