Possible syntaxt problem getting value from a form field for a que

D

DV

I created a query to to be excuted from a command button on a form after
being passed criteria from values on that form. However, when I execute the
query from the form, I'm still prompted for parameter values for the fields
I'm trying to pass to the query. In other words, the query is not using the
values from the form.

I entered the following in the query Criteria for the specific fields:

[Forms]![xfrm Research Database]![RACF ID]

I'm having the same problem with the subform where I entered:

[Forms]![xfrm Research Database]![xfrm Research Database Subform]![SYSTEM]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing values from a form to a query 9
Problem passing a value from a form to query 3
Split form 0
Populate main form from subform record 0
How do I clear a form? 0
Creating a Chart on form from selected data in query. 0
Modifying Alpha macro for use on a subform 0
Query Error when getting value form ComboBox on subform 2

Top