Linking an Unbout object??

[simon4amiee]

Hi guys,

I have a small task and having a mind block.

I have set up a Parameter query which works, and use this on a form.

What Im having a problem with is using an unbound field on the form to be the parameter.

For example in the Empty feild/box on the form I would type SMITH, and this on a click of a button next to it would run the parameter query as a subform.

 

[veraloopy]

You need to put the full form name in the query as a Criteria
For example, if you want to look up all record with the name SMITH, you need to put this in the criteria against the correct field that you want to search on.

forms!formname!unboundfieldname

For the unbound field name, look in the properties pane