Pass Through Query Linked to FORM 1

[rwn]

I had to use a Pass Through Query to obtain data (Parent Part, Component Part, Qty Per), otherwise a typical query exhibits the ''#Delete'' in the fields. The Pass Through works great for this.

However, I need to have this pass through query added to a FORM and from a field on the form called Part Number have it linked to the Pass Through Query's field called Parent Part Number and then show the field called Qty Per.

 

[dhookom]

How can you expect dlookup() work when there is no field named "txtPRTNUM_01" in the SELECT clause?

Are you sure this is a pass-through? Are both tables [Part Master] and [Product Structure] on a database server like SQL Server?

Duane
Hook'D on Access
MS Access MVP

 

[rwn]

There is a field on the Form named txtPRTNUM_01. This is a passthrough query for sure. Otherwise, a query for this table shows field data as #Deleted. It is on a server that is Pervasive database.

 

[dhookom]

A pass-through query will have absolutely no understanding of a value in a control on a form. A pass-through can only understand values contained in tables in the database server. Any other values must be included in the SQL of the pass-through. These values must be values like '4/12/2010' or '345' or 'John Smith' and can't be the name of a control on a form.

To get these "values" into the SQL of a pass-through you use the ChangeSQL() function.

Duane
Hook'D on Access
MS Access MVP